SELECT 
id, 
email 

INTO OUTFILE '/tmp/csv_users.txt' 
FIELDS TERMINATED BY '\t' 
LINES TERMINATED BY '\n'

FROM users 

ORDER BY created_at
DESC LIMIT 10

Simple example of how you can output a query as

Save a MySQL Query as a Tab or Comma separated file

mysql

MySQL