Hi,
The number of emails sent by your data driven subscription will depend on how many rows your query returns. So if your query returns 10 rows this will mean than 10 emails will be sent.
In my view the best way to set up data driven subscriptions is to send them to yourself first and then change the recipients to the user email once it has been tested successfully.