Queue System (SQL) doesn't return all values needed?

I was using this queue system for a project, and this code doesn't give all of the queued values:

PHP:

public List<String> getQueuedPlayers(){
       
        try {
           
            String q = "SELECT `uuid` FROM `users` WHERE `queued` = true";
           
            PreparedStatement st = connection.prepareStatement(q);
           
            //st.setString(1, p.getUniqueId().toString());
           
            ResultSet rs = st.executeQuery();
           
            if (rs.next()){
               
               
                String uuid = null;
                uuid = rs.getString("uuid");
               
                List<String> queued = new ArrayList<String>();
               
                queued.add(uuid);
               
                rs.close();
                st.close();
               
                return queued;
            }
           
        } catch (Exception e){
            e.printStackTrace();
        }
       
        return null;
    }

In this case, two people have the queued boolean in the database set as true. It only gives me one of the player's uuids when I use this method.
Thank you!

 

@gigosaurus @Gsoares1928, Using that creates this error:

Spoiler: Error

Code (Text):

java.sql.SQLException: Before start of result set
[17:17:08 WARN]:     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
[17:17:08 WARN]:     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
[17:17:08 WARN]:     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
[17:17:08 WARN]:     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
[17:17:08 WARN]:     at com.mysql.jdbc.ResultSetImpl.checkRowPos(ResultSetImpl.java:841)
[17:17:08 WARN]:     at com.mysql.jdbc.ResultSetImpl.getStringInternal(ResultSetImpl.java:5656)
[17:17:08 WARN]:     at com.mysql.jdbc.ResultSetImpl.getString(ResultSetImpl.java:5576)
[17:17:08 WARN]:     at com.mysql.jdbc.ResultSetImpl.getString(ResultSetImpl.java:5616)
[17:17:08 WARN]:     at com.hidden.hidden.utils.SQL.getQueuedPlayers(SQL.java:93)

Current Code:

Spoiler: Code

PHP:

public List<String> getQueuedPlayers(){
       
        List<String> queued = new ArrayList<String>();
       
        try {
           
            String q = "SELECT `uuid` FROM `users` WHERE `queued` = true";
           
            PreparedStatement st = connection.prepareStatement(q);
           
            //st.setString(1, p.getUniqueId().toString());
           
            ResultSet rs = st.executeQuery();
            do {
                String uuid = null;
                uuid = rs.getString("uuid");
               
               
                queued.add(uuid);
               
               
            } while (rs.next());
               
            rs.close();
            st.close();
           
                return queued;
           
           
        } catch (Exception e){
            e.printStackTrace();
        }
       
        return null;
    }

 

I actually found the error,
I was just using a loop without checking if rs.next() first. Thank you for your help!