Menu model

// Get all menu items in order
$menu = Menu::find(1);
$items = $menu->items; // Already ordered

// Get only top-level items (no parent)
$topLevelItems = $menu->items()->whereNull('parent_id')->get();

// Eager load items with children
$menu = Menu::with('items.children')->find(1);

$menu = Menu::create([
    'name' => 'primary'
]);

$menu = Menu::where('name', 'primary')->first();

// Add top-level item
$menu->items()->create([
    'label' => 'Home',
    'url' => '/',
    'order' => 1
]);

// Add item with children
$aboutItem = $menu->items()->create([
    'label' => 'About',
    'url' => '/about',
    'order' => 2
]);

// Add child items
$aboutItem->children()->create([
    'menu_id' => $menu->id,
    'label' => 'Team',
    'url' => '/about/team',
    'order' => 1
]);

// In controller
$primaryMenu = Menu::where('name', 'primary')
    ->with(['items' => function($query) {
        $query->whereNull('parent_id')->with('children');
    }])
    ->first();

return view('layouts.navigation', compact('primaryMenu'));

<!-- In Blade template -->
@if($primaryMenu)
<nav>
    <ul>
        @foreach($primaryMenu->items as $item)
            <li>
                <a href="{{ $item->url }}">{{ $item->label }}</a>
                
                @if($item->children->count() > 0)
                    <ul>
                        @foreach($item->children as $child)
                            <li>
                                <a href="{{ $child->url }}">{{ $child->label }}</a>
                            </li>
                        @endforeach
                    </ul>
                @endif
            </li>
        @endforeach
    </ul>
</nav>
@endif

// Get menu by name
$menu = Menu::where('name', 'primary')->first();

// Get all menus with item counts
$menus = Menu::withCount('items')->get();

// Check if menu exists
if (Menu::where('name', 'footer')->exists()) {
    // Menu exists
}