省市区（一）

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