How to display n -n relationship in php : Many to many relationship

Table_CategoryA
ID_A     -- PK
CategoryName

Table_CategoryB
ID_B     -- PK
CategoryName

Table_A_B      <-- this is known as bridge table
ID_A     -- FK
ID_B     -- FK


You can make write SQLs you need from these table like:

Select a.CategoryName as Cat_A, b.CategoryName As Cat_B
From Table_CategoryA a inner join Table_A_B ab
on a.ID_A = ab.ID_A inner join Table_CategoryB b
on ab.ID_B = b.ID_B

Select allOpen in new window

Thanks for the reply :

I want   to show it in select box , then uses these multiple values
to select some more in the Category  C table , In php do I need to simply use for loop
to get all the values  and show in "select option box " and use java script to transfer
it to input box with multiple values ? Question is How to ?