at first glance, it looks like you need to change

$query = "SELECT user_id, firstname FROM users WHERE email = $1";

to

$query = "SELECT user_id, firstname FROM users WHERE email = $2";