Mysql 递归查子孙 sql

daou 为单位表，parentid为表字段， #{value} 为想要查的单位id。

查下级不包括自身：

<select id="queryChildList" resultType="java.lang.String">
		SELECT T3.id
		FROM(
				SELECT
				     @codes as _ids,
					( SELECT @codes := GROUP_CONCAT(id)
						FROM daou
					   WHERE FIND_IN_SET(parentid, @codes)
					) as T1,
		  			@l := @l+1 as level_
				FROM daou, (SELECT @codes := #{value}, @l := 0 ) T4
				WHERE @codes IS NOT NULL
			) T2, daou T3
		WHERE FIND_IN_SET(T3.parentid, T2._ids)
</select>