sql 不在使用查询生成器 laravel 的 GROUP BY 中

I want to take how much amount of data based on the product_id taken from the table vote. on laravel this query does not work well but when i try it in mysql i run it fine is there any other solution?

这是通过 mysql 成功执行的查询：

select count(product_id) as total, `v`.*, `p`.`name` from `votes` as `v` left join `products` as `p` on `p`.`id` = (select p1.id from products as p1 where v.product_id = p1.id ) group by v.product_id

result :

这是我使用查询生成器对 laravel 进行的查询：

$count = DB::table('votes as v')->leftJoin('products as p',function($join){
  $join->on('p.id','=',DB::raw('(select p1.id from products as p1 where v.product_id = p1.id )'));
})->select(DB::raw('count(*) as total'),'v.*','p.name')->groupBy('v.product_id')->get();
dd($count);

我收到这个错误：

“SQLSTATE[42000]：语法错误或访问冲突：1055 “lookbubbledrink.v.id”不在 GROUP BY 中（SQL：select count(） 作为 全部的，v., p.name from votes as v左连接products as p on p.id=（从产品中选择 p1.id 作为 p1，其中 v.product_id = p1.id ) 分组依据v.product_id

我必须使用 group by Product_id 仅根据投票中的product_id 数量来计算有多少数据量。

您在 laravel 中使用严格模式。您可以根据自己的需要进行调整。

got to config/database.php在集合中strict=>false现在就可以走了。

  'mysql' => [
            'driver' => 'mysql',
            'host' => env('DB_HOST', '127.0.0.1'),
            'port' => env('DB_PORT', '3306'),
            'database' => env('DB_DATABASE', 'forge'),
            'username' => env('DB_USERNAME', 'forge'),
            'password' => env('DB_PASSWORD', ''),
            'unix_socket' => env('DB_SOCKET', ''),
            'charset' => 'utf8mb4',
            'collation' => 'utf8mb4_unicode_ci',
            'prefix' => '',
            'strict' => false,
            'engine' => null,
        ],