SELECT name FROM zc_system_city WHERE city_id = SELECT parent_id FROM zc_system_city WHERE city_id = SELECT parent_id FROM zc_system_city WHERE city_id = 487723 改一下这个sql 把每次子查询的结果合并上次的结果 也返回出去
SELECT GROUP_CONCAT(name) AS cities FROM zc_system_city WHERE city_id IN ( SELECT parent_id FROM zc_system_city WHERE city_id IN ( SELECT parent_id FROM zc_system_city WHERE city_id = 487723 ) )
原文地址: https://www.cveoy.top/t/topic/bXj5 著作权归作者所有。请勿转载和采集!