I would bet That
ORDER BY username ASC;
is using all your allotted memory
you can increase your memory usage in your php.ini file