$searchArray = array();
//将customer中的role_id字段中的值保存到数组searchArray中
foreach($customer as $key=>$value){
$searchArray[$key] = $value['role_id'];
}
//查询user表中user_id属于上述结果集的所有值
$temp['user_id'] = array('in',$searchArray);
$res = $user->where($temp)->select();