You can use the below query to get the Followers and the request details. Go to Reports --> New Query Report
select wo.workorderid "Request Id",wo.title "Subject",aaau.first_name "Followers",aaauc.emailid "Followers email" from workorder_cclist woc left join workorder wo on woc.workorderid=wo.workorderid left join aaauser aaau on aaau.user_id=woc.follower_id left join aaausercontactinfo aaauci on aaau.user_id=aaauci.user_id left join aaacontactinfo aaauc on aaauci.Contactinfo_id=aaauc.Contactinfo_id