问获得mysql数据库中最受欢迎的5个项目？

EN

select user_id, count(user_id) as cnt
from yourtable
group by user_id
order by cnt desc 

$results = array()
while($row = mysql_fetch_assoc($query_result)) {
   $results[] = "{$row['user_id']} ({$row['cnt']})"
   // repeat for however many results you want
}
echo "Popular user: ", implode(" & ", $results);

select user_id, count(user_id) as count from table order by count desc group by user_id

SELECT user_id, count(user_id) uid_count
FROM <<table>>
GROUP BY user_id
ORDER BY uid_count DESC
LIMIT 5;