For this, after calling our query with query, we will get the first result with fetch.

<?php
$row = $db->query('SELECT * FROM users WHERE id = 1')->fetch();
echo $row['name'];
?>