There really isn't any standard SQL to do this because it doesn't fit the set model of SQL tables.
This sounds to me like you have a problem with the way you are constructing your table. Why do you have columns for the users? You should have a table with columns like UserID & UserName, then a row for each user. Then getting the list of users becomes trivial:
SELECT * FROM user_table