If you want to use GROUP BY on a time stamp field to fetch data for each day use the below given query
SELECT DATE(FROM_UNIXTIME(timestamp_field)) AS MyDate,
COUNT(*) AS Count
FROM users_followed
GROUP BY DATE(FROM_UNIXTIME(timestamp_field))
GROUP BY DATE(FROM_UNIXTIME(timestamp_field))
ORDER BY MyDate
(Visited 113 times, 1 visits today)