Laravel从急切的负载中获得一个值

Question

I've got this query in Laravel that's returning all forums with some extra information:

return Forum::with(['messages.user' => function($query){
    $query->select('id', 'name');
}])->withCount('messages')->paginate(10);

but now it eager loads all related messages as well but I only need the author from a message. How could I get this result?

Answer 1

Assuming the table you have for your Message model is messages and that it has the columns forum_id and user_id, and the table for your User model is users you could just define a belongsToMany and get the information that way:

public function users()
{
    return $this->belongsToMany(User::class, 'messages')->distinct();
}

then:

return Forum::with(['users' => function($query){
     $query->select('users.id', 'users.name');
}])->withCount('messages')->paginate(10);

Hope this helps!