递归查询，只能查询两级

 select * from sys_bs_area_info t where exists 

          (select * from sys_bs_area_info t1,sys_bs_area_info t2 where  t1.bain_id = t2.bain_parent_id and  t1.bain_id=t.bain_id )

转载于:https://blog.51cto.com/2520378/1158642