MySQLi:选择列中最常见的5个数据，并按显示顺序返回

SELECT 列名, COUNT(*) AS count
FROM 表名
GROUP BY 列名
ORDER BY count DESC
LIMIT 5;

<?php
$mysqli = new mysqli("数据库主机", "用户名", "密码", "数据库名");

if ($mysqli->connect_errno) {
    echo "连接数据库失败：" . $mysqli->connect_error;
    exit();
}

$query = "SELECT country, COUNT(*) AS count FROM users GROUP BY country ORDER BY count DESC LIMIT 5";
$result = $mysqli->query($query);

if ($result) {
    while ($row = $result->fetch_assoc()) {
        echo $row['country'] . ": " . $row['count'] . "<br>";
    }
    $result->free();
} else {
    echo "查询失败：" . $mysqli->error;
}

$mysqli->close();
?>