With AS 递归用法

 with temp as
(
  select * from T_SJZX_RESOURCE_DIRECTORY where PARENT_ID= #{0}
  union all
  select B.* from temp A,T_SJZX_RESOURCE_DIRECTORY B where A.ID=B.PARENT_ID
)
SELECT DISTINCT * FROM temp