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（）来实现