这将是我的解决方案,althoug一点都不优雅
<?PHP
$dbc = new MysqLI(DBHOST,DBUSER,DBPASS,DB);
$result = $dbc->query("
SELECT
p.Group as 'group',
GROUP_CONCAT(name) as names
FROM prueba p
GROUP BY p.Group
");
?>
<table>
<tr>
<th>Group</th>
<th>Name</th>
</tr>
<?PHP while($row = $result->fetch_assoc()){
$names = split(",",$row["names"]);
?>
<tr>
<td><?PHP echo $row["group"] ?> </td>
<td><?PHP echo $names[0]; array_shift($names) ?></td>
</tr>
<?PHP foreach( $names as $name){ ?>
<tr>
<td></td>
<td><?PHP echo $name ?></td>
</tr>
<?PHP } ?>
<?PHP } ?>
</table>