Mysql Join Query 9

Ive the following code :

INSERT INTO table student

SELECT employee_id

FROM table employee WHERE emp_location == student_location

i want to insert a employee_id into table student which also an employee_id as foreign key where the location of a student matched the ones of the employee location.