sql递归查询，怎么转成如图格式？

Question

create database IF NOT EXISTS test ;
use test;
DROP TABLE IF EXISTS test.base;
CREATE TABLE  test.base(  
father string ,  
son string 
)  
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' ; 

insert into base (father,son ) value('周营','陈庄'); 
insert into base (father,son ) value('河南省','周口市'); 
insert into base (father,son ) value('周口市','沈丘县'); 
insert into base (father,son ) value('沈丘县','周营'); 
insert into base (father,son ) value('周营','陈庄'); 
insert into base (father,son ) value('安徽省','阜阳市'); 
insert into base (father,son ) value('阜阳市','临泉县'); 
insert into base (father,son ) value('临泉县','黄岭镇'); 
insert into base (father,son ) value('安徽省','界首市'); 
insert into base (father,son ) value('杭州市','萧山区'); 
insert into base (father,son ) value('上海市','浦东新区'); 
insert into base (father,son ) value('浦东新区','唐镇'); 

Answer 1

不应该sql查出来全量然后用代码处理吗