php - Joining 2 Tables and show the same column repeatedly based on its associative ID -

hi not sure how put in brief sentences, have db table following

user table

• user_id
• username
• and on...

item

• item_id
• item_name

item_equipped

• equipped_id head (fk item_id)
• hand (fk item_id)
• user_id (fk user_id in user table)

i generate query display following format

user_id | head | head_item_name | hand | hand_item_name | ...

so far able this:

select user.user_id, user.username,         equipments.head, equipments.head_acc,         equipments.hand,         equipments.acc, equipments.body gw_member_equipped equipments left join gw_member user on user.memberid = equipments.member_id 

which (i have brutally honest) doesn't much.

i tried perform inner join between item , item_equipped unable individual name each item (based on item id)

you need join item table 2 times item_equipped table.

you can use below query desired output column shown in question..

select user.user_id,        item_equipped.head,        item_heads.item_id head_item_id, -- if want can remove column        item_heads.item_name head_item_name,               item_equipped.hand,        item_hands.item_id hand_item_id,  -- , column these columns same previous select columns        item_hands.item_name hand_item_name   user, item item_heads, item item_hands, item_equipped  user.user_id = item_equipped.user_id    , item_heads.item_id = item_equipped.head    , item_hands.item_id = item_equipped.hand