mysql 查询上级信息以及下级的数量

2023-04-20 本文已影响0人风度翩翩的程序猿

SELECT id,nickname,himg,(SELECT count(*) FROM t_user WHERE pid = t1.id) as count FROM t_user t1 WHERE pid = 0