In MySQL, there is a special ways to get data between two days.
select * from ret_bonus where DATE(start_time) between date_sub(curdate(), interval 5 day) and CURDATE()
Above SQL returns data between today and 5days before today.
date_sub(curdate(), interval 5 day)
This MySQL command returns 5days before today.