cms/app/Models/NavigationItem.php

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\Factories\HasFactory;

class NavigationItem extends Model
{
    //

    protected $fillable = [
        'label',
        'url',
        'page_id',
        'order',
        'parent_id',
        'target',
    ];

    public function page()
    {
        return $this->belongsTo(Page::class);
    }

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

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

    public function getFinalUrlAttribute()
    {
        if ($this->page_id) {
            return '/' . $this->page->slug;
        }
        return $this->url;
    }
}