“关注我，让你的生活笑出声来！”

1. select*fromuser,(selectcount(*)count,fans.useridfromfansgroupbyfans.userid)fans_countwherefans_count.userid=user.idorderbyfans_countunt