select * from shop_goods g where g.syscategoryid in
(
SELECT s.id FROM shop_syscategory s
CONNECT BY PRIOR id= parentid
START WITH s.id = 11
)
select * from enation_user u where u.areaid in
(
SELECT region_id FROM SHOP_REGION s
CONNECT BY PRIOR region_id = parentid
START WITH region_id =4
)