To do specifically what you are asking -
You would JOIN the table that holds the main booking information, where the booking_id is defined, with the payment table, grouped by the booking_id. The 1st table you have shown is the booking details, the items that are part of the booking, and it doesn’t directly have anything to do with getting the sum of the paid amounts.
However, I suspect your overall goal is to get both the amount booked/owed and the amount paid and/or sum/subtract those to show the amount due. If so, you need to use a UNION ALL query, between two SELECT queries, one to get the sum from the booking details table, grouped by the booking_id, and the second to get the sum from the payment table, grouped by the booking_id. If you want to perform the sum/subtraction of those two values in the query, you would use the UNION ALL query as a sub-query. The outer query would sum the sub-totals (the amount paid would need to made negative) and group by the booking_id.