select username,count(uid) as num from biao group by username
select count(uid) as number from table group by uid
