大佬，mysql查询一个字段并且查询该字段在另一个字段中出现的次数
我想查出数据按openid来分组，然后并且查出这个openid在右边tui_openid里面出现的次数，求大神指导一下sql语句，谢谢

select openid,count(*) as counts,tui_openid,(select count(*) as count2 from fans where tui_openid=openid) from fans GROUP BY openid ORDER BY counts desc
我这样写不对哦