php - query the data day by day -

I have the name of this database table click

  id user site id date 1 3 1 2014- 02-15 2 3 2 2014-02-15 3 3 2014-02-15 4 3 4 2014-02-15 5 3 5 2014-02-15 6 3 4 2014-02-16 7 3 5 2014- 02 - 16 8 3 6 2014-02-16 9 3 7 2014-02-16 10 3 8 2014-02-16 11 3 9 2014-02-17 12 3 2014-02-17 13 3 4 2014-02- 17 14 3 1 2014-02-17 15 3 1 2014-02-17 16 3 2 2014-02-18 18 3 3 2014-02-18 18 3 4 2014-02-18 19 3 7 2014-02-18 20 3 6 2014-02-18 21 3 1 2014-02-19 22 3 2 2014-02-19 23 3 2014-02-19 24 3 2014-02-19 25 3 5 2014-02-19 26 3 8 2014 - 02-19  

My question is how to calculate the click any time by the user id

I like the output

 < Code> User ID should be clicked on date 3 5 2014-02-15 3 5 2014-02-16 3 5 2014-02-17 3 5 2014-02-18 3 5 2014-02-19  

Hope that my question is clear

  select user id, click form In COUNT (id), `date` by FORM` table` group` date`, user_id