Number of rows can be obtained by

SELECT COUNT (user_id) FROM users;