Program to generate CSV Report Facility from Wordpress Database with data from different tables wp_posts and wp_postmeta

We require the facility to generate a CSV Report Facility from Wordpress Database with data from different tables wp_posts and wp_postmeta . We have a developed a membership website for motor enthusiasts. Members have 1 or more car which they use to participate in events. The website has details of member, cars operated by the members, events & ticket price options. The members participate in different types of motoring events which they book on the website. Booking of these events is done thru the plugin “Event Bookings” in conjunction with Woocommerce. Payment is by way of Stripe. We are looking to be able to create a summary of all bookings, in CSV Format, for particular events. I am trying to pull all the information from wordpress tables wp_posts and wp_postmeta to include all the information I require about a person going to an Event (car race) in an order. I have included some code below but it’s not getting populated and also pictures of the database showing table wp_postmeta with the values in the rows that I want to pull information from… We cannot get the code to work and we need assistance with this. The end result of this project will be an easy to use function that will be accessible online and which will be used by our clients to generate a CSV Report for specified events booked on the website