Joining table data

Joining table data

I have a table of:
id title type expl bubble_content onfocus req dorder
label mirror
1 Fullname 1 1 Your fullname Yes 0 0 0
NULL
Then another table of:
id fieldid relid dorder
4 1 2 0
5 1 1 0
How would I join the two tables so that the result would be something like:
0 => array(
'id' => 1,
'title' => 'Fullname',
.... etc ....
'relid' => 2,
'relid' => 1),
1 => array(
.... etc ....
))
I've tried using INNER JOIN / LEFT JOIN but this produces two rows/arrays
for each relid, I would really like all the data for the particular
fieldid to exist within the same array, as illustrated above.