查询一级商户下的所有的二级商户

 SELECT
          ID,MCHNT_LVL,MCHNT_CODE,MCHNT_NAME,MCHNT_ABBR_NAME,PARENT_ORG_CODE
      FROM
          T_MCHNT_INFO
      WHERE
        MCHNT_LVL='1' AND MCHNT_STATUS = 'B' AND DELETE_FLAG='0'
        AND PARENT_ORG_CODE in (SELECT ID FROM T_MCHNT_INFO WHERE MCHNT_LVL='0' AND MCHNT_STATUS = 'B'
        AND DELETE_FLAG='0' AND MCHNT_CODE= '123456789'
        )