Help with Code

[Parker Clack]

I am wanting to display a profile field in the user.php file in the admincp directory.

Currently the code to pull the data from the table is

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

What would I change this to so it also pulls data from the userfield for that userid?

Thanks.