Get all parent categories in a root parent first order

@melkhior

So let's assume this is the structure...

Parent Category
    |- Child Category

Which looks like this in the db..

id   |    name              |    category_id (parent category id)
------------------------------------------------
1    |    parent category   |    null
2    |    child category    |    1

What you'll want to do is have the cartegory_id as a foreign key to it's parent. Secondly you will want to setup the proper model relations.. here's an example:

class Category extends Model {
    // Each category may have one parent
    public function parent() {
        return $this->belongsToOne(static::class, 'category_id');
    }

    // Each category may have multiple children
    public function children() {
        return $this->hasMany(static::class, 'category_id');
    }
}

So now that the model relations are defined and you want to display the categories in a view, you'll do something like this to pass them to your view..

view()->composer('homepage', function($view) {
    $view->with('categories', Category::with('children')
            ->whereNull('category_id')
            ->orderBy('name', 'asc')
            ->get());
});

And finally displaying them like so in your blade template..

<ul>
    @foreach ($categories as $parent)
        <li>{{ $parent->name }}
            @if ($parent->children->count())
                <ul>
                @foreach ($parent->children as $child)
                    <li>{{ $child->name }}</li>
                @endforeach
                </ul>
            @endif
        </li>
    @endforeach
</ul>

Hope that helps give you some insight in how to create same table relations :)

how to pass $categories variable to blade.

Cool @Braunson How I Can Learn Such Relations Like This ? That Was Really Helpful And Now For Me !