如何计算和显示具有相同日期的数据库中的行数（PHP）

I have a database that contains three different columns: domain, date, length (in that order). What I'm trying to do is count the occurrence of every unique date in the database without knowing what the end date is in the database. The start date is always todays date.I have a database that contains three different