Select columns from query

\App\Products::where('xfs', '>',10)
  ->with(['users' => function($q){
    $q->select('id', 'email', 'name'); //you have to select the relation column
  }])->get()

@VILFAGO - Thanks! :)

Forgot something, my code will not work ;)

You need to have the key and foreign key of the relation, so in this case id should be selected. Unless, Eloquent cannot reorganise data fetched.

I update the answer above

@VILFAGO - Hehe. Thanks, I tried it and accidentally I tried it with the ids before i read your update.

Another question concerning this: Is it possible to "flatten" this collection into one dimension? I know there's a flattenmethod for collections, but that doesn't work as expected. :( I need the data to export it to a csv and I don't know how to handle this multidimension collection.

If you want a flat result, you better use a join than an eloquent relation

Why does collapsenot work here? https://laravel.com/docs/5.7/collections#method-collapse I only get empty results.

These are not arrays, but instance of Model

Ah ok. Then I will try the joins :) Thanks for your help, @vilfago !