mysql 取每个分组中时间最近的记录

SELECT
    *
FROM
    baoma_auction AS a
WHERE
    NOT EXISTS (
        SELECT
            1
        FROM
            baoma_auction
        WHERE
            goods_id = a.goods_id
        AND a.modify_datetime < modify_datetime
    )
AND member_id=30;