Nested categories in Laravel?

Question

Laravel

Please tell me how to display nested categories correctly and in order not to load the database?
there is a category

table a category description table for each language

Category model

protected $table = 'categories';

    protected $fillable = [
        'image','parent','sort_order','published'
    ];

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

    public function description(){
        return $this->hasMany(CategoryDescription::class, 'category_id');
    }

CategoryDescription Model

protected $table = 'category_descriptions';

    protected $fillable = [
        'category_id','language_id','name','description','meta_title','meta_description','meta_keyword'
    ];

Answer 1

You have everything well organized. The only thing I highly recommend is https://github.com/GeneaLabs/laravel-model-caching. And so everything is fine with you.

Answer 2

in order not to load the database when sampling, use MPTT (Modified Preorder Tree Traversal)