计算一周的mysql值，然后从星期一开始再次计数？

i have a count query that counts how many times a user has viewed another users profile. It currently just counts all the rows in the table, however i was wondering if there was a way in php to use a calculation that says count all rows in the table 'ptb_profile_views' from monday to sunday and then start from 0 again on the following monday and count all the values for that week and do not include any counts from the previous week, im not sure this is possible thought because it would need some time of memory aspect behind it,i have a count query that counts how many times