select * from circle_order where draw_id = #{drawId} and trading_id = #{tradingId} and user_id = #{userId} and YEARWEEK(DATE_FORMAT(FROM_UNIXTIME(pay_time),'%Y-%m-%d')) = YEARWEEK(NOW())")

pay_time是要查询时间的字段