sql - MySql Select data from SubQuery when master query has groupby clause -

i have 2 tables in mysql db.

1) networks (networkid, networktype)  2) users (id, networkid, ipaddress) 

using [networkid , ipaddress] defines unique users.

now, want use group by clause on networktype , @ same time want list count of users below:

select (select count(distinct ipaddress) users         networkid in nr.networkid ) userscount networks nr group networktype; 

but due reason gets 0 users.

when run following queries

select group_concate(nr.networkid) networks nr group networktype; 

then getting valid values ',' separated.

thanks in advance.

updated per new information needed group by.

how upvote efforts @ least.

latest sqlfiddle

select     mysub.count,      nr.`networkid`      `networks` nr,  (select      count(`ipaddress`) count,     `networkid`      `users`      `networkid` in (     select          `networkid`              `networks`    ) group      `networkid`) mysub     nr.`networkid` = mysub.`networkid`     group nr.`networkid`