Save sql file from query
SELECT users.first_name, users.middle_name, users.last_name, users.email, users.mobile, patient_profiles.niko_id FROM users RIGHT JOIN patient_profiles ON users.id = patient_profiles.patient_id where users.role = 'patient' AND patient_profiles.niko_id IS NOT NULL INTO OUTFILE '/var/lib/mysql-files/users.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n';