Level 75
You have to use joins for that
$users = User::select('users.name, users.age, comments.comment')
->join('comments', 'users.id', '=', 'comments.user_id')
->get();
Jun 30, 2021
4
Level 1
How to add more selects in eloquent query
Hi, I build a query and loaded relationships with it then select some columns from a model but want to add/select more columns from related modes/relationships.
for example $user = User::with('comments') ->select('name', 'age') ->addSelect('comment') // i want to add columns from comments model. ->get();
is there any way to select column at this point ?
Level 122
using relationships the comments will be loaded as children
if you want them on the same 'level' and not nested then you must use a join
if you only want to load certain column from the child then you can specify this in the with() function
people don't use joins because if user has many comments then the user data has to be repeated for every comment since a row of the result can only contain one comment
Level 1
i want to follow eager loading n dont want to use joins
Level 75
So
$users = User::with('comments:id,user_id,comment')->get();
https://laravel.com/docs/8.x/eloquent-relationships#eager-loading-specific-columns
Please or to participate in this conversation.