How to write a query to view all parent of all subcategories

@Sinnbeck

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

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

@ga46 So its a tree? All of them are of the same class?

@Sinnbeck yes

@ga46 Not really. Can you show some code? All the subcategories are on the same level ? And you want to get every single parent all the way to the top, for each subcategory?

@Sinnbeck

sub-1 ----- parent-1
sub-2-----parent-1
sub-3-----parent-2
sub-4----parent-2

suppose i have access all "sub" ,1,2,3,4 now I want to get all of my sub-category parent, that's mean ---parent-1,parent-2

@ga46 So just one for each?

$subs = Category::with('parent')->where('level', 12)->get();