select t1.userid,
t1.username,
t1.pid,
t2.sums
from t1
inner join
(select pid, count(*) as sums
from t1
group by pid) t2
on t1.userid=t2.pid[/quote]
朋友,你好啊。你这个查询出来就一条记录。
select userid , username ,pid,
(select count(*) from t1 where pid=v.userid) as sums
from t1 v