❔ ✅ Tree category EF Core

public class Category
{
    public int Id { get; set; }

    public string Name { get; set; } = string.Empty;
    public string Title { get; set; } = string.Empty;
    
    public ICollection<Category> Subcategories { get; set; } = new List<Category>();
    public int? CategoryId { get; set; }
}

public class Category
{
    public int Id { get; set; }

    public string Name { get; set; } = string.Empty;
    public string Title { get; set; } = string.Empty;
    
    public ICollection<Category> Subcategories { get; set; } = new List<Category>();
    public int? CategoryId { get; set; }
}

        var query = await this.Context()
            .Categories
            .Include(x => x.Subcategories)
            .Where(x => x.Id == 1)
            .ToListAsync();

        var query = await this.Context()
            .Categories
            .Include(x => x.Subcategories)
            .Where(x => x.Id == 1)
            .ToListAsync();