urgent - how to select village count with single query - clan

Hello - I am creationg my own game but I am stucked when selecting clan members. I got this query

$members = $db->query("SELECT users.username, count(villagedata.vid) as villcount, users.id, villagedata.name, villagedata.pop FROM users,villagedata WHERE users.cid = ".$cid." GROUP BY users.id");

But count(villagedata.vid) is giving me 6 instead of 2. (6 is total amount of villages on whole server).
Can you tell me how should I select only count of villages JUST FOR THAT ONE USER ?

 

SELECT username, (SELECT COUNT(vid) FROM villagedata) as villcount, id, FROM users WHERE cid = ".$cid." GROUP BY id

PHP:

 

but I need village count for only ONE CERTAILY SELECTED user

It means

SELECT username,COUNT_OF_HIS_VILLAGES, id FROM users WHERE cid=".$cid." GROUP by id

Thanks anyways

 

SELECT u.username, (SELECT COUNT(v.vid) FROM villagedata as v WHERE v.column_for_user = u.id) as villcount, u.id, FROM users AS u WHERE u.cid = ".$cid." GROUP BY u.id

 

Okay, that's better
I got this

$members=$db->query("SELECT u.username, (SELECT COUNT(v.vid) FROM villagedata as v WHERE v.owner_id = u.id) as villcount, v.pop, u.id FROM users AS u, villagedata as v WHERE u.cid = ".$cid." GROUP BY u.id");

And it works! I was so stupid lol. Thank you

 

Your welcome !