MySQL 5.7

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

CREATE TABLE users (id INT AUTO_INCREMENT PRIMARY KEY, 
                    name VARCHAR(255), 
                    type VARCHAR(255));
CREATE TABLE team_members (team_id INT, 
                           user_id INT, 
                           mod_time INT);
CREATE PROCEDURE create_data_users(IN users_list TEXT, IN data_user_team_id INT)
BEGIN
	DECLARE name VARCHAR(255);
	REPEAT
		SET name = TRIM(SUBSTRING_INDEX(users_list, ',', 1));
		SET users_list = CASE WHEN LOCATE(',', users_list)
		                      THEN TRIM(SUBSTRING(users_list FROM 1 + LOCATE(',', users_list)))
		                      ELSE '' END;
		INSERT INTO users (users.name, users.type)
		VALUES (name, "team_data");
		INSERT INTO team_members (team_id, user_id, mod_time)
		VALUES (data_user_team_id, LAST_INSERT_ID(), UNIX_TIMESTAMP());
	UNTIL users_list = '' END REPEAT;
END
CALL create_data_users('John, Bob, Jim', 123);
CALL create_data_users('Alex, Adam', 456);
CALL create_data_users('Mike', 789);
SELECT * FROM users;
SELECT * FROM team_members;


id
name
type


1
John
team_data

2
Bob
team_data

3
Jim
team_data

4
Alex
team_data

5
Adam
team_data

6
Mike
team_data




team_id
user_id
mod_time


123
1
1712806688

123
2
1712806688

123
3
1712806688

456
4
1712806688

456
5
1712806688

789
6
1712806688

id	name	type
1	John	team_data
2	Bob	team_data
3	Jim	team_data
4	Alex	team_data
5	Adam	team_data
6	Mike	team_data

team_id	user_id	mod_time
123	1	1712806688
123	2	1712806688
123	3	1712806688
456	4	1712806688
456	5	1712806688
789	6	1712806688