/**
* Notes:省市级联动
* Created by xxg@seabig.cn
* Date: 2020/6/4
* Time: 17:24
*/
public function getCityData()
{
$cityList = $this->getAll(array("pid = 1"));
$data = array();
foreach ($cityList as $v) {
$data[$v['id']] = array(
"id" => $v['id'],
"name" => $v['name'],
"subList" => array()
);
//获取二级
$cityTow = $this->getAll(array("pid = {$v['id']}"));
foreach ($cityTow as $l) {
$data[$v['id']]['subList'][$l['id']] = array(
"id" => $l['id'],
"name" => $l['name'],
"subList" => array()
);
//获取三级
$cityThree = $this->getAll(array("pid = {$l['id']}"));
foreach ($cityThree as $t) {
$data[$v['id']]['subList'][$l['id']]['subList'][] = array(
"id" => $t['id'],
"name" => $t['name']
);
}
}
}
//格式化数据
$res = array();
foreach ($data as $val) {
$item = array();
foreach ($val['subList'] as $v) {
$item[] = $v;
}
$res[] = array(
'id' => $val['id'],
'name' => $val['name'],
'subList' => $item
);
}
return $res;
}
数据库表:
链接:https://pan.baidu.com/s/1L29fBe2EHblJbmBuzf38Ng
提取码:6ch0
数据返回结果: