SELECT
@r AS _id,
(SELECT @r := `parent_id` FROM `test_table` WHERE `id` = _id) AS parent_id
FROM
(SELECT @r := 5 -- 传入id
, @l := 0) vars,
`m_link`
WHERE @r <> 0
利用ID递归查询父ID,一层层往上找
SELECT
@r AS _id,
(SELECT @r := `parent_id` FROM `test_table` WHERE `id` = _id) AS parent_id
FROM
(SELECT @r := 5 -- 传入id
, @l := 0) vars,
`m_link`
WHERE @r <> 0
利用ID递归查询父ID,一层层往上找