Laravel-获取父级和所有可能的子级的查询

// 定义模型类
class Category extends Model
{
    public function children()
    {
        return $this->hasMany(Category::class, 'parent_id');
    }

    public function parent()
    {
        return $this->belongsTo(Category::class, 'parent_id');
    }

    public function getAllDescendants()
    {
        return $this->children()->with('getAllDescendants');
    }

    public function getAllAncestors()
    {
        return $this->parent()->with('getAllAncestors');
    }
}

// 使用递归关联查询获取父级和所有可能的子级的查询
$category = Category::with('getAllDescendants', 'getAllAncestors')->find($categoryId);

// 获取所有子级
$descendants = $category->getAllDescendants;

// 获取所有父级
$ancestors = $category->getAllAncestors;