Db\Result\Pdo::fetchAll

public fetchAll ([mixed $fetchStyle], [mixed $fetchArgument], [mixed $ctorArgs])

Returns an array of arrays containing all the records in the result This method is affected by the active fetch flag set using Phalcon\Db\Result\Pdo::setFetchMode

$result = $connection->query("SELECT * FROM robots ORDER BY name");
$robots = $result->fetchAll();