부모로부터 자식 가져오기

 SELECT
    LEVEL,
    MENU_ID,
    P_MENU_ID,
    MENU_NM
    FROM  BNT_MENU
 WHERE USE_YN = 'Y'
     START WITH MENU_ID = 2
     CONNECT BY  PRIOR   MENU_ID =  P_MENU_ID
     ORDER SIBLINGS BY LEVEL ASC