mysql 数据库 递归查询语句

SELECT * FROM ( 
		SELECT 
			@r AS id, 
			(SELECT @r := father FROM user_relainfo where id = @r) AS father
		FROM 
			(SELECT @r := 455) vars, 
			user_relainfo h 
		WHERE @r <> 409) T1 

SELECT * FROM
  (
    SELECT * FROM dedao.user where super_id > 0
     ORDER BY super_id, id DESC
  ) realname_sorted,
  (SELECT @pv := #{userId}) initialisation
  WHERE (FIND_IN_SET(super_id,@pv)>0 And @pv := concat(@pv, ',', id))

第一段 往上递归

第二段往下递归