如何在typeorm中连接树形结构中的每个子实体

import {Entity, PrimaryGeneratedColumn, Column, Tree, TreeParent, TreeChildren} from "typeorm";

@Entity()
@Tree("closure-table") // 使用闭包表存储树形结构关系
export class TreeNode {
    @PrimaryGeneratedColumn()
    id: number;

    @Column()
    name: string;

    @TreeParent()
    parent: TreeNode;

    @TreeChildren()
    children: TreeNode[];
}

{
  "type": "mysql",
  "host": "localhost",
  "port": 3306,
  "username": "root",
  "password": "password",
  "database": "mydatabase",
  "synchronize": true,
  "logging": true,
  "entities": ["src/entities/*.ts"],
  "cli": {
    "entitiesDir": "src/entities"
  }
}

import {getRepository} from "typeorm";

// 获取树形结构实体的存储库
const treeNodeRepository = getRepository(TreeNode);

// 获取树的根节点
const rootNode = await treeNodeRepository.findOne({ where: { parent: null } });

// 遍历树的每个子节点
function traverseTree(node: TreeNode) {
    console.log(node.name);
    if (node.children) {
        for (const childNode of node.children) {
            traverseTree(childNode);
        }
    }
}

traverseTree(rootNode);