这将是我的解决方案，althoug一点都不优雅
<?php$dbc = new MySQLI(DBHOST,DBUSER,DBPASS,DB);$result = $dbc->query("SELECtp.Group as 'group',GROUP_CONCAt(name) as namesFROM prueba pGROUP 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>
