select applyinfo.sceneid,count(distinct usersname) as users
from applyinfo ,usersinfo
where applyinfo.usersname = usersinfo.usersname
and usersinfo.userssex = '男'
group by applyinfo.sceneid