SELECT * FROM by_app_categories WHERE c_name LIKE CONCAT('%', (SELECT `name` FROM b_catelist WHERE type="wangluo"), '%') 转载于:https://www.cnblogs.com/jpfss/p/8744721.html