INSERT INTO oa_holiday_management 
( id, user_id, join_day, `status`, is_first, created_at, created_by, updated_at, updated_by )
	
	SELECT
		frame_user.id,
		frame_user.id AS user_id,
		IFNULL(
			frame_user.createdat,
		now()) AS join_day,
		0 AS `status`,
		1 AS is_first,
		now() AS created_at,
		'1' AS created_by,
		now() AS updated_at,
		'1' AS updated_by 
	FROM
		frame_user
		LEFT JOIN oa_holiday_management ON oa_holiday_management.user_id = frame_user.id 
	WHERE
	oa_holiday_management.user_id IS NULL