INSERT INTO otp_authorised_emp(otp_event_id,otp_emp_id,prefered_otp_method,status)
SELECT 2,X.id,'All',1 FROM proll_employee X
LEFT OUTER JOIN otp_authorised_emp Y ON X.id = Y.otp_emp_id