select distinct e.id,e.name,e.level,e.up_level
from crm_district a
inner join crm_district b on a.id=b.up_level or a.id=b.id
inner join crm_district c on b.id=c.up_level or b.id=c.id
inner join crm_district d on c.id=d.up_level or c.id=d.id
inner join crm_district e on d.id=e.up_level or d.id=e.id
where a.id=1
select distinct d.id
from 表结构如下 a inner join 表结构如下 b on a.id=b.pid or a.id=b.id
inner join 表结构如下 c on b.id=c.pid or b.id=c.id
inner join 表结构如下 c on b.id=d.pid or c.id=d.id
where a.id=1