您可以在php代码中执行下面的查询，并在页面中打印结果。

<?php
$q = "SELECT 
  CASE WHEN `day` = 7 then 'Sunday'
    WHEN `day` = 1 then 'Monday'
    WHEN `day` = 2 then 'Tuesday'
    WHEN `day` = 3 then 'Wednesday'
    WHEN `day` = 4 then 'Thursday'
    WHEN `day` = 5 then 'Friday'
    WHEN `day` = 6 then 'Saturday' 
  END AS dayname, 
GROUP_CONCAT(hour) AS hours_grouped 
FROM TABLE-NAME 
GROUP BY `day`";

$con=mysqli_connect("localhost","my_user","my_password","my_db");
// Check connection
if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }

$result=mysqli_query($con,$q);

while ($row = mysql_fetch_array($result)) {
    echo $row['dayname'].': '.$row['hours_grouped'].'<br />';
}
?>