sql标签做,给你条sql语句

select a.userid,username,num from ks_user a,(select articleinput,count(*) as num from ks_article group by articleinput)b where a.username=b.articleinput order by b.num desc