JoinWith(['application'], false) ->select('cate_id,app_id,name,icon,sort,type,native_url,h5_url,android_url,ios_url,app_store_url,redirect_type,') ->orderBy('sort asc')->asArray()->all(); $icon_Items = array_column($data,'icon'); $icon_Items = array_unique($icon_Items); $icon_Infos = CoinImage::getItemsByIds($icon_Items); $cate_app_item = []; foreach($data as &$value){ if($value['icon']){ $value['icon'] = $icon_Infos[$value['icon']]['base_url'].$icon_Infos[$value['icon']]['file_url']; }else{ $value['icon'] = ''; } } foreach($data as $item){ $cate_app_item[$item['cate_id']] []= $item; } return $cate_app_item; } }