public function parent() {
    return $this->belongsTo('App\Hashtag','parent_id');
}
        
public function childs() {
    return $this->hasMany('App\Hashtag','parent_id','id')->orderBy('created_at'); 
}

Controller: Eager Loading Specific Columns, nested: Parent and Child

Um die Beziehungen in der Abfrage im Controller gleich zu laden, kann folgendes Beispiel verwendet werden:

Hashtag::where('name','like','%'.$hashtag.'%')->select(['id', 'name','parent_id'])->with('childs.childs:parent_id,name', 'parent:id,name')

ManytoMany mit der gleichen Tabelle

Tabellenlayout

Tabelle hashtags; Spalten: id, name,created_at

Pivot-Tabele hashtag_hashtag; Spalten: id, hashtag_id, parent_id

Model

public function parent() {
    return $this->belongsToMany('App\Hashtag','hashtag_hashtag','hashtag_id','parent_id'); 
}
        
public function childs() {
    return $this->hasMany('App\Hashtag','parent_id','id')->orderBy('created_at'); 
}

Sync

Hashtag::where("name","Windows Batch")->first()->parent()->sync(Hashtag::where("name","Windows")->first())