MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE my_table
(
email VARCHAR(32), 
foreign_key_id INT DEFAULT 1, 
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
SET @value := JSON_ARRAY('one@email.com', 'two@email.com', 'three@email.com');
INSERT INTO my_table (email)
SELECT email
FROM JSON_TABLE( @value,
                 "$[*]" COLUMNS ( email VARCHAR(32) PATH "$" 
                                ) 
               ) AS parse_JSON;
SELECT * FROM my_table;


email
foreign_key_id
created_at


one@email.com
1
2020-02-02 12:54:17

two@email.com
1
2020-02-02 12:54:17

three@email.com
1
2020-02-02 12:54:17

email	foreign_key_id	created_at
one@email.com	1	2020-02-02 12:54:17
two@email.com	1	2020-02-02 12:54:17
three@email.com	1	2020-02-02 12:54:17