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!