How can I pass parameter to stored procedure through a query?
You can pass third parameter value as

CALL test(@vote_value, @score, (select u.id from Users u), 'WEEK');

Please put appropriate WHERE clause in above inline query.