Categorized column

[lars]

I've joined two tables (one parent table and one child table) by id.

The seceond table has many entries per id. When I display the result I get all results in a flat view. I would like to categorize the view so that
I can only see one parent entry in the first row and all depending child
entries in the second. Is that possible?

$query="SELECT t1.fam_name,t1.fam_street,t1.fam_zip,t1.fam_city,t1.fam_country,t1.id,t2.chi_name,t2.chi_birthdate,t2.parent_id
FROM parents as t1,children as t2
WHERE t1.id=t2.parent_id
GROUP BY t1.fam_name";