二维数组字符串字段求并集并且去重

一，数据结构

查询结果集合$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',
)