如何按匹配日期对mysqli_fetch_array结果进行分组？

// 假设已经连接到MySQL数据库并选择了数据库

$query = "SELECT * FROM your_table ORDER BY date_column";
$result = mysqli_query($connection, $query);

$grouped_results = array();

while ($row = mysqli_fetch_array($result)) {
    $date = $row['date_column'];

    if (array_key_exists($date, $grouped_results)) {
        $grouped_results[$date][] = $row;
    } else {
        $grouped_results[$date] = array($row);
    }
}

// 打印按日期分组后的结果
foreach ($grouped_results as $date => $rows) {
    echo "日期: " . $date . "<br>";
    foreach ($rows as $row) {
        // 处理每一行数据
        echo $row['column1'] . " " . $row['column2'] . "<br>";
    }
    echo "<br>";
}