SELECT opt tlabel_id tlabel_name FROM oss_push_trump opt LEFT JOIN SELECT GROUP_CONCAT label_id AS label_id GROUP_CONCAT label_name AS label_name FROM uc_user_label WHERE FIND_IN_SET uc_use

要将LIMIT 1改为循环查询，您可以使用子查询来实现。以下是修改后的查询语句：

SELECT opt.*, t.label_id, t.label_name FROM oss_push_trump opt LEFT JOIN ( SELECT GROUP_CONCAT(label_id) AS label_id, GROUP_CONCAT(label_name) AS label_name FROM uc_user_label WHERE FIND_IN_SET(uc_user_label.label_id, (SELECT push_label_id FROM oss_push_trump) ) > 0 ) t ON opt.push_label_id = t.label_id