SELECT u.*, s.* FROM users AS u INNER JOIN users_states AS us ON u.user_id = us.user_id INNER JOIN states AS s ON us.state_id = s.state_id WHERE s.state_id = ? ORDER BY u.name ASC