Oracle 关联自己

SELECT T.ID,
       CASE
         WHEN T.PARENT_ID = 0 THEN
          T.NAME
         ELSE
          T2.NAME
       END AS NAME,
       CASE
         WHEN T.PARENT_ID = 0 THEN
          T.R
         ELSE
          T2.R
       END AS R,
       D.NAME AS RNAME
  FROM INFO T
  LEFT JOIN INFO T2
    ON T.PARENT_ID = T2.ID
  LEFT JOIN DOMAIN D
    ON (T.R || T2.R) = D.ID