php - Laravel 组违规

Question

这个问题已经有答案了:

Error related to only_full_group_by when executing a query in MySql (18 个回答)

已关闭 4 年前。

我想在 auth 用户的收件箱中获取所有消息以及向他发送消息的人员姓名。

我有疑问

    $user_id=Auth::id();
    $messages=Chat::with('user')
    ->where('user_id',$user_id)
    ->groupBy('friend_id')
    ->limit(10)
    ->get();

但是 Laravel 不肯让我明白这一点，并说:

SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mojaodeca.chats.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by (SQL: select * from chats where user_id = 1 group by friend_id limit 10)

Answer 1

用这个

 $user_id=Auth::id();
 $messages=Chat::with('user',function($q){
                     $q->groupBy('friend_id')
                  })
    ->where('user_id',$user_id)
    ->limit(10)
    ->get();