1、需要的数据格式
[
'行业1' => ['机构1' , '机构2'],
'行业2' => ['机构3' , '机构4']
]
service_industry(industry_id , industry_name)
service(service_id , service_name , add_time , industry_id)
遍历出每个行业下的所有服务机构
方法一:
① table : service , service_industry
② field : industry_name , group_concat(service_id)
③ group : industry_id
==> idArr
④ foreach($idArr as $key => $val) {
$sId = explode(',' , $val['service_id']);
$list[$val['industry_name']] = service->where(['service_id' => ['in' , $sId]])->select();
}
方法二:
① table : service、serivice_industry
② field : service_name , service_id , industry_name
==> serArr
③ foreach($serArr as $key => $val) {
$list[$val['industry_name']][] = $val;
}