MySQL: Getting Username from UserID

[Dismounted]

[sql]SELECT award_user.issue_id, award_user.award_id, award_user.userid, award_user.issue_reason, award_user.issue_time, user.username
FROM " . TABLE_PREFIX . "award_user AS award_user
LEFT JOIN " . TABLE_PREFIX . "user AS user ON (userid)
ORDER BY issue_id DESC
LIMIT $limit[/sql]