[amykhar]

$users = $db->query_read("
		SELECT user.userid, user.username,  user.email, user.ipaddress,userfield.*
		FROM " . TABLE_PREFIX . "user as user 
LEFT JOIN ".TABLE_PREFIX."userfield ON user.userid=userfield.userid 
		WHERE usergroupid = 4
		ORDER BY username
	");

That's roughly it. You may need to tinker and adjust syntax. I wrote it cold.