[kh99]

Sorry, my mistake - you also have to add the userfield fields to the list of fields, like:

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