一,数据结构
查询结果集合$complete1如上图,对 room_id 求并集,然后去重
$room_arr_all=array_column($complete1,'room_id');
//对数组每个元素都进行字符串转数组的操作
array_walk($room_arr_all,function(&$item,$key){$item=explode(',',$item);
});
//二维数组转成一维数组并去重
$new_room_id_arr=array_reduce($room_arr_all,function($carry,$item){return array_merge($carry,$item);
},[]);
$new_room_id_arr = array_unique($new_room_id_arr);
最终结果如下
array (0 => '705',1 => '707',2 => '706',3 => '708',4 => '709',5 => '809',6 => '685',7 => '677',8 => '678',9 => '679',10 => '680',11 => '681',12 => '682',13 => '842',14 => '721',15 => '722',16 => '840',17 => '839',18 => '838',19 => '837',20 => '693',
)