Parent id into select query

I need Category::find(78)->slug as 'parent_slug' into query, but how to do it?

Category::where('parent_id', 78)
                    ->select('name', 'slug', DB:raw(Category::find(78)->slug as 'parent_slug'))
                    ->get();

MichalOravec

4 years ago

Best Answer

Level 75

You need to use join for that.

Category::select('categories.name', 'categories.slug', 'parent.slug as parent_slug')
    ->join('categories as parent', 'categories.parent_id', '=', 'parent.id')
    ->where('categories.parent_id', 78)
    ->get();

https://laravel.com/docs/9.x/queries#joins

1 like

Please or to participate in this conversation.