如何实现 elasticsearch 类似于sql 嵌套子查询

 
如何实现如下sql：select sum(page_click_num) from users_log where user_id in(select user_id from users_log where date_str >= ? and date_str <= ? group by user_id having sum(attendance_num) > 0) 
 
在es 6.x 版本