How do we get all results (sql query) to be stored in a variable so that we can later use that variable to send out an email to multiple email addresses?

How do we get all results to be stored in a variable so that we can later use that variable to send out an email to multiple email addresses?

In a Site WF running daily

There are multiple Sql Queries configured the same (just on different views in db) pulling back multiple email (contacts) Storing in a collection variable - in the WF History, we can see only one email address is being stored (there should be several) 

When testing the query in the wf, we get multiple results - SQL Query is a success

we want the collection variable to take each email address and separate it by a comma or a semicolon - for emailing purposes.