mysql 连续签到7天 查询

select * from (
select p.id pid,p.name,p.create_time,u.id,u.mobile,u.realname,u.authname,u.register_time,u.register_ip from project p inner join user u on p.user_id = u.id and p.id in (
  
 Select DISTINCT  t1.project_id  from project_manhour t1
 join  project_manhour t2 on  t1.project_id=t2.project_id 
 join  project_manhour t3 on  t2.project_id=t3.project_id
 join  project_manhour t4 on  t3.project_id=t4.project_id 
 join  project_manhour t5 on  t4.project_id=t5.project_id
 join  project_manhour t6 on  t5.project_id=t6.project_id
 join  project_manhour t7 on  t6.project_id=t7.project_id
 
 where DATEDIFF(t1.add_time,'2016-08-08 00:00:00')=0 and t1.manhour>0
 
 and  DATEDIFF(t2.add_time,t1.add_time)=1 and t2.manhour>0
 and  DATEDIFF(t3.add_time,t2.add_time)=1 and t3.manhour>0
 and  DATEDIFF(t4.add_time,t3.add_time)=1 and t4.manhour>0
 and  DATEDIFF(t5.add_time,t4.add_time)=1 and t5.manhour>0
 and  DATEDIFF(t6.add_time,t5.add_time)=1 and t6.manhour>0
 and  DATEDIFF(t7.add_time,t6.add_time)=1 and t7.manhour>0
 
 )
) tb1 inner join project_member tb2 on tb1.pid = tb2.project_id