Just to note, you can probably save yourself a query by pulling all the data you need at once from the first query.

Then you can store the data that you need for the second output in an array which already has the duplicates taken out.

Then for the dropdown, you simply loop through the array instead of calling another call to the DB....