$list = $message->alias('a')->join('LEFT JOIN company as b ON a.uid = b.id left join user as u on a.student1=u.id left join course_theme as c on a.theme=c.id')->field('a.id,a.uid,a.type,a.num,a.people_num,a.theme,a.teacher,a.date,a.end_date,a.ctime,a.status,a.student1,b.company,u.name,u.img,u.tel,c.theme')->order('id desc')->limit($Page->firstRow.','.$Page->listRows)->select();
$user_id = array_column($list,"student1");
foreach($user_id as $key=>$v){
$where_user_id['student1'] = $v;
$res_user_id = $message->where($where_user_id)->count();
dump($res_user_id);
echo $message->getLastSql();
}
//dump($user_id);$list是数据库查出来的很多数据。$user_id是从这个结果集中获取到所有的用户id信息，然后通过foreach遍历查询这些用户id在报名表里面出现的次数，我想把遍历查询的结果赋值给上面的$list里面对应的每一行，请问一下该如何合并加入进去数组呢？最佳答案
