Im developing a php booking system based on timeslot for daily basis. Ive set up 4 database tables!

1. Bookslot (which store all the ids - id_bookslot, id_user, id_timeslot)
2. Timeslot (store all the times on 15 minutes gap ex: 09:00, 09:15, 09:30, etc)
3. Therapist (store all therapist details)

4. User (store all the members detail)

   ID_BOOKSLOT ID_USER ID_THERAPIST ID_TIMESLOT

   1           10          1        1  (09:00)  
   2           11          2        1  (09:00)  
   3           12          3        2  (09:15)
   4           15          3        1  (09:00)
   

Now, my issue is, it keep showing repeation for timeslot when i want echoing the data for example:

            thera a       thera b       thera c
  -------------------------------------------------
 09:00       BOOKED      available      available
 09:00     available       BOOKED       available
 09:00     available     available        BOOKED 
 09:15     available       BOOKED       available

as you can see, 09:00 showing three times, and i want something like below

           thera a       thera b       thera c
-------------------------------------------------
 09:00      BOOKED        BOOKED         BOOKED    
 09:15     available      BOOKED       available

There might be something wrong with joining the table or else. The code to join the table

$mysqli->query("SELECT * FROM bookslot RIGHT JOIN timeslot ON bookslot.id_timeslot = timeslot.id_timeslot LEFT JOIN therapist ON bookslot.id_therapist = therapist.id_therapist"

if anyone have the solution for this system, please help me out and i appriciate it much!