Navigate to Analytics | Custom queries | Click on Add new query.
After configuring the query as per your requirement, save the query by going to Query | Save as
After saving the query, set the query action to "send email report". Yyou can add multiple recipient email address ( internal / external users ) separated by comma.
Now, you should be able to see the newly configured custom query under your custom queries list.
Click on Scheduled report edit button on the query and set the "time sent " time to receive the report as per your schedule.
NOTE: When query is sent to multiple recipients, there is an arrow to expand and list the recipients. This doesn't expand which prevents you from seeing who the query was sent to. This is an expected behavior.