$user = $db->query("SELECT id, email FROM users WHERE email='fredrik@reite.com'")->fetch(PDO::FETCH_LAZY);

var_dump($user);echo "<br><br>";
var_dump($user);echo "<br><br>";
var_dump($user);echo "<br><br>";

gives
object(PDORow)#4 (3) { ["queryString"]=> string(59) "SELECT id, email FROM users WHERE email='fredrik@reite.com'" ["id"]=> int(1) ["email"]=> string(17) "fredrik@reite.com" }

object(PDORow)#4 (3) { ["queryString"]=> string(59) "SELECT id, email FROM users WHERE email='fredrik@reite.com'" ["id"]=> NULL ["email"]=> NULL }

object(PDORow)#4 (3) { ["queryString"]=> string(59) "SELECT id, email FROM users WHERE email='fredrik@reite.com'" ["id"]=> NULL ["email"]=> NULL }


with PDO::FETCH_OBJ it works like

object(stdClass)#4 (2) { ["id"]=> int(1) ["email"]=> string(17) "fredrik@reite.com" }

object(stdClass)#4 (2) { ["id"]=> int(1) ["email"]=> string(17) "fredrik@reite.com" }

object(stdClass)#4 (2) { ["id"]=> int(1) ["email"]=> string(17) "fredrik@reite.com" }