您的解决方案可以源自:

Your solution can be derived from: Subtract month and day mysql

例如(DATE_SUB(curdate(), INTERVAL 1 MONTH)

SELECT COUNT(*), wedding, DATE_SUB(weddate,INTERVAL 1 MONTH) FROM weddingtable