[SQL] select possibile?

[LeaderGL]

così dovrebbe funzionare:

SELECT u1.*, u2.n_users
FROM users AS u1,
(
   SELECT COUNT(idusers ) AS n_users
   FROM users 
) AS u2
WHERE idusers = '10'