mysql递归查询父级 并以竖线拼接

 

 

SELECT GROUP_CONCAT(hor.name SEPARATOR ' | ' )
    from hr_organization hor
    where id in (
    select a.curr_id from (
    SELECT @id AS curr_id
        , (
            SELECT @id := GROUP_CONCAT(parent_id)
            FROM hr_organization
            WHERE FIND_IN_SET(id, @id)
        ) AS p_ids, @l := @l + 1 AS LEVEL
    FROM hr_organization, (
            SELECT @id := 'youorgid', @l := 0
        ) b
    WHERE @id IS NOT NULL and @id !='' order by LEVEL DESC
    ) a
    )