SELECT A.DISPLAY_ORDER, A.NAME PARENT_NAME,  B.NAME CHILD_NAME 
FROM CATEGORY A
LEFT OUTER JOIN  CATEGORY B 
ON B.ID_PARENT_CATEGORY = A.ID_CATEGORY