Syntax error at end of input (? specifier)

[mr-far]

Hello, i've got a little problem. I want to get some user by ID, i use ? to do it. But ,there is a syntax problem.

let user = sqlx::query_as!(UserModel, r#"SELECT * FROM users WHERE id = ?"#, id)
        .fetch_one(&**pool)
        .await;

error: error returned from database: syntax error at end of input
  --> src/routes/users.rs:20:16
   |
20 |     let user = sqlx::query_as!(UserModel, r#"SELECT * FROM users WHERE id = ?"#, id)
   |                ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
   |

[mehcode]

Please refer to https://docs.rs/sqlx/latest/sqlx/macro.query.html#query-arguments

Note that each database has its own method of query arguments. Given the error message, my guess is you're using Postgres and want to use $1 instead.