Sorgunuz bu olsun:
SELECT username FROM user ORDER BY RAND() LIMIT 1