เรียนสอบถามเรื่องการ Query ข้อมูลจาก MySQLมาแสดงแบบจัดกลุ่มข้อมูลแสดงผลบนเว็บใช้ภาษา PHP

SELECT PROVINCE_NAME, AMPHUR_NAME FROM TB_AMPHUR LEFT JOIN TB_PROVINCE ON TB_AMPHUR.PROVINCE_ID = TB_PROVINCE.PROVINCE_ID

<table width="600" border="1">
  <tr>
    <th width="98"> <div align="center">PROVINCE_NAME</div></th>
    <th width="98"> <div align="center">AMPHUR_NAME</div></th>
  </tr>
<?php
$row_count =  mysqli_num_rows($query);
$result=$query->fetch_assoc();
?>
  <tr>
    <td rowspan="<?=$row_count?>"><div align="center"><?php echo $result["PROVINCE_NAME"];?></div></td>
	<td><div align="center"><?php echo $result["AMPHUR_NAME"];?></div></td>

  </tr>
<?php while($result=$query->fetch_assoc() ){ ?>
  <tr>
	<td><div align="center"><?php echo $result["AMPHUR_NAME"];?></div></td>
  </tr>
<?php } ?>
</table>

$sql = "SELECT GROUP_CONCAT(AMPHUR_NAME) AS AMPHUR_NAME,PROVINCE_NAME FROM AMPHUR LEFT JOIN PROVINCE ON AMPHUR.PROVINCE_ID = province.PROVINCE_ID GROUP BY province.PROVINCE_ID";

<table width="600" border="1">
  <tr>
    <th width="98"> <div align="center">PROVINCE_NAME</div></th>
    <th width="98"> <div align="center">AMPHUR_NAME</div></th>
  </tr>
<?php
while($result=mysqli_fetch_array($query,MYSQLI_ASSOC))
{
?>
  <tr>
    <td><div align="center"><?php echo $result["PROVINCE_NAME"];?></div></td>
	<td><div align="center"><?php echo $result["AMPHUR_NAME"];?></div></td>

  </tr>
<?php
}
?>
</table>

<table width="600" border="1">
	<tr>
		<th width="98"> <div align="center">PROVINCE_NAME</div></th>
		<th width="98"> <div align="center">AMPHUR_NAME</div></th>
	</tr>
<?php while($result=$query->fetch_assoc() ){ 
	$amp_list = explode(',', $result->AMPHUR_NAME); $c = count($amp_list);
?>
	<tr>
		<td rowspan="<?=$c?>" align="center"><?php echo $result["PROVINCE_NAME"];?></td>
		<td align="center"><?=$amp_list[0]?></td>
  </tr>
<?php 
	for($i=1; $i<$c; $i++){
?>
	<tr><td align="center"><?=$amp_list[$i]?></td></tr>
<?php 
	}
} ?>
</table>