您需要有一个子查询，以获取每个日期的最新日期
user ID。
SELECt a.*, c.*FROM users a INNER JOIN payments c ON a.id = c.user_ID INNER JOIN ( SELECt user_ID, MAX(date) maxDate FROM payments GROUP BY user_ID ) b ON c.user_ID = b.user_ID AND c.date = b.maxDateWHERe a.package = 1
