test131:

How can I fetch data

1 user can many item

1 item can add many Status item

User

|---------------------|------------------|
|          id         |       name       |
|---------------------|------------------|
|          1          |    TESTNAME      |
|---------------------|------------------|

ITEM

|---------------------|------------------|
|      Item_id        |      name        |
|---------------------|------------------|
|          1          |      ITEM1       |
|---------------------|------------------|

STATUS

|---------------------|------------------|------------------|
|      status_id      |      name        |      item_id     |
|---------------------|------------------|------------------|
|          1          |     status1      |       1          |
|---------------------|------------------|------------------|

USER_ADD_ITEM

|---------------------|------------------|------------------|
|      User_item      |      user_id     |      item_id     |
|---------------------|------------------|------------------|
|          1          |    1             |       1          |
|---------------------|------------------|------------------|

I try to Loop data by

my sql = SELECT * FROM USER_ADD_ITEM a 
         LEFT JOIN USER u ON a.user_id = u.id
         LEFT JOIN ITEM i ON a.item_id = i.id
         LEFT JOIN STATUS s ON a.item_id = s.item_id

I'm confusing now did my database right? how can I loop data with have status inside loop