I guess you can try something like this:
PHP Code:
$q1 = "SELECT `id` FROM `GamesPlayed`";
$result = mysql_query($q1);
$row = mysql_fetch_array($result);
$max = count($row);
for($i = 0; $i <= $max; i++)
{
$q2 = "SELECT `id` FROM `Members` WHERE `maingame` = '".$row[$i]."'";
$result2 = mysql_query($q2);
echo $row[$i] . "-->" . mysql_num_rows($result);
}