如何在Entity Framework Core2.2中实现自递归的亲子关系数据加载？

// 创建实体类
public class Category
{
    public int CategoryId { get; set; }
    public string Name { get; set; }

    public int? ParentCategoryId { get; set; }
    public Category ParentCategory { get; set; }

    public ICollection<Category> ChildCategories { get; set; }
}

// 创建上下文类
public class AppDbContext : DbContext
{
    public DbSet<Category> Categories { get; set; }

    protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
    {
        optionsBuilder.UseSqlServer("your_connection_string");
    }
}

// 配置父子关系
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
    modelBuilder.Entity<Category>()
        .HasOne(c => c.ParentCategory)
        .WithMany(c => c.ChildCategories)
        .HasForeignKey(c => c.ParentCategoryId);
}

// 加载自递归的亲子关系数据
using (var context = new AppDbContext())
{
    var category = context.Categories
        .Include(c => c.ChildCategories)
            .ThenInclude(c => c.ChildCategories)
                .ThenInclude(c => c.ChildCategories)
        .FirstOrDefault(c => c.CategoryId == categoryId);
}