select
a2.area_id as parent_id,
a2.area_name as parent_name,
a1.area_id as child_id,
a1.area_name as child_name
from area as a1
left join area as a2
on a1.parent_id = a2.area_id
单表sql查询省市县
最新推荐文章于 2025-05-27 09:29:30 发布
select
a2.area_id as parent_id,
a2.area_name as parent_name,
a1.area_id as child_id,
a1.area_name as child_name
from area as a1
left join area as a2
on a1.parent_id = a2.area_id