SELECT * FROM 表名 WHERE DATE_FORMAT( FROM_UNIXTIME( 时间戳字段名), '%Y-%m-%d' ) = DATE_FORMAT( NOW( ), '%Y-%m-%d' ) GROUP BY xxx