mysql 树形结构查询

WITH RECURSIVE temp as (
    SELECT t.* FROM sys_depart t WHERE t.id = #{id}
    UNION ALL
    SELECT t.* FROM sys_depart t INNER JOIN temp ON t.id = temp.parent_id
)
SELECT * FROM temp WHERE org_type = '2'