pdo.php

<?php

$pdo = new PDO(
    'mysql:host=localhost;dbname=yii2_basic_tests',
    '',
    ''
);

$sth = $pdo->prepare("SELECT id, test FROM user");
$sth->execute();
$r = $sth->fetchAll(PDO::FETCH_ASSOC);

echo '<pre>'; var_dump($r); echo '</pre>'; die();
/**
 * OUTPUT:
 * <pre>array(2) {
 *  [0]=>
 *  array(2) {
 *    ["id"]=>
 *    string(1) "1"
 *    ["test"]=>
 *    string(1) "0"
 *  }
 *  [1]=>
 *  array(2) {
 *    ["id"]=>
 *    string(1) "2"
 *    ["test"]=>
 *    string(1) "1"
 *  }
 *}
 */