查询指定年份（比如 2026 年）的 4 月到 7 月

SELECT * FROM merchant_user_discount WHERE YEAR(create_time) 2026 AND MONTH(create_time) BETWEEN 4 AND 7;