SELECT T2.id, T2.title,T2.controller,T2.method,T2.urlFROM ( SELECT @r AS _id, (SELECT @r := parent_id FROM menu WHERE id = _id) AS parent_id, @l := @l + 1 AS lvl FROM (SELECT @r := 31, @l := 0) vars, menu m WHERE @r <> 0) T1JOIN menu T2ON T1._id = T2.idORDER BY T1.lvl DESC;
Demo