What is the best way to load every children of current model? about nestablecollection

[sdebacker]

The best way is using CTEs with PostgreSQL or waiting for MySQL 8: https://stackoverflow.com/questions/31641504/adjacency-list-model-vs-nested-set-model-for-mysql-hierarchical-data

Otherwise, for small trees, you can add a children method in you model, like this:

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

and then in a loop:

$model->load('children');

[darron1217]

@sdebacker Thanks for the feedback :)

[NormanEdance]

Can you guys post implementation, cuz I'm stuck too