select
  a.userid,count(distinct b.userid) 
from
  [user] a join info b
on
  a.userid=b.userid
group by
  a.userid

------解决方案--------------------

也不知道对不对 select count(*) from user inner join info on user.userid=info.userid where .....自己测试下