求大神帮忙看一下sql
SELECT id,username,id_father,Team_con
FROM (
SELECT
@r AS _id,
(SELECT @r := id_father FROM ibcusers WHERE username = _id) AS parent_username
FROM
(SELECT @r :=’’) vars,
ibcusers
WHERE @r IS NOT NULL) T1
INNER JOIN ibcusers T2
ON T1._id = T2.username
ORDER BY id
这条sql传的参数有的可以正确返回数据(很多条)传有的参数则会报子查询返回多行。。。。这个是怎么回事 求大神解答!!!