摘要： SELECT area_.id, area_.name FROM ( SELECT @r AS _id, (SELECT @r := parentid FROM `hk_area` WHERE id = _id) AS parentid, @l := @l + 1 AS lvl FROM (SELECT @r := 2106, @l := 0) vars, `hk_area` h... 阅读全文