求大神帮忙看一下sql
求大神帮忙看一下sql
欢迎使用Markdown编辑器
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
O
原创
2020-05-11 19:41:04 ·
138 阅读 ·
0 评论