public function getTree()
{
$data = [];
$level1 = Db::name("dict_area")
->field("id,name,parent_id")
->where("level", 1)
->select();
$level1 = array_column($level1, 'name', 'id');
$data[100000] = $level1;
foreach ($level1 as $key => $value) {
$level2 = Db::name("dict_area")
->field("id,name")
->where("level", 2)
->where("parent_id", $key)
->select();
if (!empty($level2)) {
$level2 = array_column($level2, 'name', 'id');
$data[$key] = $level2;
}
foreach ($level2 as $k => $val) {
$level3 = Db::name("dict_area")
->field("id,name")
->where("level", 3)
->where("parent_id", $k)
->select();
if (!empty($level3)) {
$level3 = array_column($level3, 'name', 'id');
$data[$k] = $level3;
}
}
}
api_return(0, $data, '操作成功');
}
image.png
image.png
image.png
