code:
$persons = array(); $tags = array(); while($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { if(!isset($persons[$row["id"]])) { $persons[$row["id"]]= $row; $tags[ $row['id'] ] = array(); } $tags[ $row['id'] ][] = $row['tag']; } foreach($persons as $pid=>$p){ $tag1 = $p["tag"]; $tag1ish = $tags[$p['id']]; }