Database Query Question

[Itworx4me]

Hello,

I have people sign up using there Real Name on my forum. I am using this code to pull some info from the database.

PHP Code:

$users = $db->query_read("SELECT userid, username FROM " . TABLE_PREFIX . "user WHERE usergroupid IN (6,9) ORDER BY username ASC "); 


Is there a way to code it so that it sorts by there last name instead of the first name?

Thanks,
Itworx4me