COUNT subselect

Hi there,

I have a query with a lot of where .. in ( .. group by having count(..) .. )
for example:
select userid
from users
where userid in
(
select userid
from user_group_index
group by userid
having count(userid)>3
)

What I would like to is have the count in the select too.
What is performance-wise the best way to do this?
Is it possible to do this without using the join statement?

p.s. the subqueries can be nested several times. I would like to show that counts too.

Regards,
Martien