How exactly do SQL Subqueries work?

[Jaxel]

I'm trying to figure this one out... I have one query... that returns a set of rows.

$villages = $vbulletin->db->query_read("
SELECT conquest_players.*, conquest_nations.*, user.username
FROM conquest_players AS conquest_players
LEFT JOIN conquest_nations AS conquest_nations ON conquest_players.nationID = conquest_nations.nationID
LEFT JOIN user AS user ON conquest_players.forumID = user.userid
ORDER BY user.username ASC
");

I am pulling each row with a while loop...

while ($village = $vbulletin->db->fetch_array($villages))
{
$intel = $vbulletin->db->query_first("
SELECT * FROM conquest_intel
WHERE playerID = ".$player[playerID]."
AND villageID = ".$village[playerID]."
");

eval('$villagesHTML .= "' . fetch_template('conquest_villages_bit') . '";');
}

This works great, but the problem is that if I am paginating the results by 30 listings, then the $intel query adds an extra 30 queries per page. I'm wondering if there was a way I could combine the two SQL statements together