sql inner join is on find array

[xoceunder]

Hola a todos es que tengo un consulta para poder buscar y unir dos tabla

Tabla 1

Código MySQL:

CREATE TABLE `output_formats` (
  `access_output_id` int(11) NOT NULL,
  `output_name` varchar(255) DEFAULT NULL,
  `output_key` varchar(255) DEFAULT NULL,
  `output_ext` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
 
INSERT INTO `output_formats` (`access_output_id`, `output_name`, `output_key`, `output_ext`) VALUES
(1, 'HLS', 'm3u8', 'm3u8'),
(2, 'MPEGTS', 'ts', 'ts'),
(3, 'RTMP', 'rtmp', '');
 

Tabla 2

Código MySQL:

CREATE TABLE `lines` (
  `id` int(11) NOT NULL,
  `member_id` int(11) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `allowed_outputs` mediumtext DEFAULT NULL,
  `updated` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
 
INSERT INTO `lines` (`id`, `member_id`, `username`, `password`, `allowed_outputs`, `updated`) VALUES
(0, 1, 'test', 'test', '[1,2,3]', '2024-06-24 11:33:05'),
(1, 1, 'test', 'test', '[1,2,3]', '2024-06-24 11:33:20');
 

Mi consulta

Código MySQL:

SELECT t1.`access_output_id`, t1.`output_key` FROM `output_formats` t1 INNER JOIN `lines` t2 ON FIND_IN_SET(t1.access_output_id, t2.allowed_outputs) WHERE t2.id =1;
 

Y no me muestra los 3