使用TypeORM获取自引用关系中的数据

import { Entity, PrimaryGeneratedColumn, Column, ManyToOne, OneToMany } from 'typeorm';

@Entity()
export class Category {
  @PrimaryGeneratedColumn()
  id: number;

  @Column()
  name: string;

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

  @OneToMany(() => Category, category => category.parent)
  children: Category[];
}

import { getRepository } from 'typeorm';

// 获取Category实体类的存储库
const categoryRepository = getRepository(Category);

// 获取所有顶级分类（没有父级的分类）
const topLevelCategories = await categoryRepository.find({ parent: null });

// 遍历顶级分类，并获取其子级分类
for (const category of topLevelCategories) {
  const children = await categoryRepository.find({ parent: category });
  console.log(`Category ${category.name} has children:`, children);
}