[mariadb] 계층형 테이블 에서 특정 로우의 하위 로우들 가져오기

WITH RECURSIVE CTE AS (
SELECT
    COMPANY_NAME
,COMPANY_ID
,PARENT_ID
,GROUP_ORDER
,COMPANY_DEPT
FROM COMPANY
WHERE COMPANY_ID = #{companyId}  -- 가져오자하는 노드
UNION ALL
SELECT
T1.COMPANY_NAME
,T1.COMPANY_ID
,T1.PARENT_ID
,T1.GROUP_ORDER
,T1.COMPANY_DEPT
FROM COMPANY T1
INNER JOIN CTE T2 ON T1.PARENT_ID = T2.COMPANY_ID
)
SELECT
COMPANY_NAME
,COMPANY_ID
,PARENT_ID
,GROUP_ORDER
,COMPANY_DEPT
FROM CTE
WHERE 1=1