MySql由child找parent

记录sql:

SELECT s.*, @code :=
(SELECT  ParentCode FROM mytable
WHERE Code = @code) AS tmp
FROM  (SELECT  @code := 10) vars
STRAIGHT_JOIN mytable s
WHERE @code IS NOT NULL;