I tried to convert this query to CodeIgniter but I'm just a beginner. I find how can I convert simple SQL but this code is so difficult for me. Is there anyone can help me for convert this code to CodeIgniter?

```
SELECT
    cm.customerID,cm.customerName, cm.phone,adr.address,
    adr.city, adr.zipcode,
    bd.bookingDate,bd.startBooking,
    bd.endBooking, pt.type
FROM
    customers cm, addresses adr, bookings bd, paymentTypes pt,customer_payment cp
WHERE
    cm.customerID=adr.customerID AND
    cm.customerID=bd.customerID AND
    pt.paymentID=cp.paymentID AND
    cm.customerID=cp.customerID
ORDER by
    bookingDate;

```