查询父路径mysql

查询id为103的父路径如下，记录下，哈哈。。。。。

SELECT
GROUP_CONCAT( parent_id ) pid
FROM
(
SELECT
@a AS _id,
( SELECT @a := parent_id FROM sys_dept WHERE dept_id = _id ) AS parent_id
FROM
( SELECT @a := 103 ) vars,
sys_dept h
WHERE
@a <> 0
ORDER BY
parent_id ASC
) a