MYSQL 字符串转为列表，作为关联条件查询【有待完善，只是能用】

SELECT * 
FROM ttmro_product.prod_catalog
WHERE catalog_id IN (
SELECT DISTINCT
    * 
FROM
    (
SELECT
    SUBSTRING_INDEX(
    SUBSTRING_INDEX(
    (
SELECT
    setting.text 
FROM
    com_temp_setting setting
    LEFT JOIN modular_detail detail ON detail.relation_id = setting.relation_id 
WHERE
    detail.relation_type = '03' 
    AND setting.tenant_id = 'c8b8ffeee0b048cb91162659c5983921d086eb5d60744c9b97a1cac36691928a' 
    AND setting.del_flag = '0' 
    LIMIT 1 
    ),
    ',',
    help_topic_id + 1 
    ),
    ',',- 1 
    ) AS num 
FROM
    mysql.help_topic 
WHERE
    help_topic_id < LENGTH(
    (
SELECT
    setting.text 
FROM
    com_temp_setting setting
    LEFT JOIN modular_detail detail ON detail.relation_id = setting.relation_id 
WHERE
    detail.relation_type = '03' 
    AND setting.tenant_id = 'c8b8ffeee0b048cb91162659c5983921d086eb5d60744c9b97a1cac36691928a' 
    AND setting.del_flag = '0' 
    LIMIT 1 
    ) 
    ) - LENGTH(
    REPLACE (
    (
SELECT
    setting.text 
FROM
    com_temp_setting setting
    LEFT JOIN modular_detail detail ON detail.relation_id = setting.relation_id 
WHERE
    detail.relation_type = '03' 
    AND setting.tenant_id = 'c8b8ffeee0b048cb91162659c5983921d086eb5d60744c9b97a1cac36691928a' 
    AND setting.del_flag = '0' 
    LIMIT 1 
    ),
    ',',
    '' 
    ) 
    ) + 1 
    ) T2
)