PHP PDO grouping results

pdo_group_results.php

<?php
$stmt = $pdo_connection->query('SELECT id, name, surname FROM people');
$people = $stmt->fetchAll(\PDO::FETCH_GROUP | \PDO::FETCH_UNIQUE | \PDO::FETCH_ASSOC);

/*
$people will now contain:
array(
  1 => array(
    'name' => 'Juan',
    'surname' => 'Sorin',
  ),
  ...
)

if you omit \PDO::FETCH_UNIQUE, array of arrays will returned
(useful if multiple rows can have same id)
array(
  1 => array(
    0 => array(
      'name' => 'Juan',
      'surname' => 'Sorin',
    ),
    1 => ...
  ),
  ...
)
*/