在TypeORM中对嵌套实体进行排序时出现问题

import { getRepository } from 'typeorm';

// 假设有一个Parent实体，包含一个嵌套的Child实体数组
@Entity()
class Parent {
  @PrimaryGeneratedColumn()
  id: number;

  @OneToMany(() => Child, child => child.parent)
  children: Child[];
}

@Entity()
class Child {
  @PrimaryGeneratedColumn()
  id: number;

  @ManyToOne(() => Parent, parent => parent.children)
  parent: Parent;

  @Column()
  name: string;
}

// 获取Parent实体的Repository
const parentRepository = getRepository(Parent);

// 构建查询语句，对嵌套的Child实体按照name字段进行升序排序
const query = parentRepository.createQueryBuilder('parent')
  .leftJoinAndSelect('parent.children', 'child')
  .orderBy('child.name', 'ASC');

// 执行查询
const parents = await query.getMany();