How to get rid of duplicate output values ​​of a PDO::query() query?

Question

PHP

Good afternoon. I am learning PHP and MariaDB stack. There is the following code for accessing the database:

$db = new PDO('mysql:host=localhost;dbname=taxi', 'root', '123');
$sql = 'SELECT * FROM autos WHERE id = 1';
$result = $db->query($sql);
$arr = $result->fetch();
var_dump($arr);

var_dump returns the following result:

As you can see, each underlined line duplicates the values ​​of the previous one, but with a through indexing. Is there any way to get rid of this?

Answer 1

$result = $db->query($sql, PDO::FETCH_ASSOC);

Answer 2

just need to use wrappers under mysql