Laravel get a collection of relationship items

Question

I'm stuck on this what seems like a simple task.

I have a User that has many Shops that have many Products..

I'm trying to get all the Products for a certain User.

This is working, and is returning the Shops with their Products

\Auth::user()->shops()->with('products')->get(); 

But I need a Collection of only the Products. I tried the following but it's messing up the Query

\Auth::user()->shops()->with('products')->select('products.*')->get(); 

Any idea what I'm doing wrong? Thank you!

Answer 1

You can use this :

\Auth::user()->shops()->with('products')->get()->pluck('products')->flatten(); 

if you don't want replicate, you can use ->unique()

If you want to directly work on a query (for performances):

  Product::whereHas('shops', function($query){     $query->where('user_id', auth()->user()->id);  })->get();