laravel 查询以某个字段为键名(可用于去重) mysql 统计数量可用count(1)
collect(DB::table('task_channel')->selectRaw('task_id,COUNT(1) as total')->whereIn('task_id',$taskArr)->where('channel',$channel_id)->groupBy('task_id')->get())->keyBy('task_id')->toArray()
用keyBy()来实现
collect(DB::table('task_channel')->selectRaw('task_id,COUNT(1) as total')->whereIn('task_id',$taskArr)->where('channel',$channel_id)->groupBy('task_id')->get())->keyBy('task_id')->toArray()
用keyBy()来实现