Save query result in CSV format directly into zip file

I want to save a query result in CSV format directly into a zip file, without zip the file after save it in csv. How can I do that?