//查询三级联动的地址信息树状结构--未应用
public static functiongetRegionAddressTree()
{
$addressList=self::find()->with([
'children',
'children.children',
])->where([self::tableName().'.parent_id'=>1])->asArray()
->all();
$provinceList= [];
foreach($addressListas$province) {
$cityList= [];
if(!empty($province['children'])) {
foreach($province['children']as$city) {
$districtlist= [];
if(!empty($city['children'])) {
foreach($city['children']as$district) {
$districtlist[] = [
'district_id'=>$district['region_id'],
'district_name'=>$district['region_name'],
];
}
}
$cityList[] = [
'city_id'=>$city['region_id'],
'city_name'=>$city['region_name'],
'district_list'=>$districtlist,
];
}
}
$provinceList[] = [
'province_id'=>$province['region_id'],
'province_name'=>$province['region_name'],
'city_list'=>$cityList,
];
}
return$provinceList;
}
