Need help with outputing query group names

I am trying to come up with a way to output group headers, then all the records under each group header etc. It would be easy, except there is a twist with what i want to do.

Normally if I have this set of data (which I ‘borrowed’ from a site that showed the closest to what I’m looking for):

Example Table Setup:

TABLE [Numbers]

(Name, NUMBER)

Dave Bosky              843-444-4444

Dave Bosky              843-555-5555

Matthew Small        843-111-1111

Matthew Small      _843-222-2222

Matthew Small        843-333-3333

I could use the following code:

<cfoutput query="somequery" group="name">

        #name#<br>

        <cfoutput>

                #phonenumber#<br>

        </cfoutput>

        <hr>

</cfoutput>

And get this:

Dave Bosky

843-444-4444

843-555-5555

-------------------

Matthew Small

843-111-1111

843-222-2222

843-333-3333

-------------------

BUT, my actual tables are not set up like this. Rather than recording each name with each record, I would have an ID that is the foreign key for another table.

Current table set up would look like this:

TABLE [People]

(ID, NAME)

1 Dave Bosky        

2 Matthew Small  

TABLE [Phones]

(PEOPLE_ID, NUMBER)

1              843-444-4444

1              843-555-5555

2              843-111-1111

2              843-222-2222

2              843-333-3333

So this output would actually give me this with my current setup and the query code above:

1

843-444-4444

843-555-5555

-------------------

2

843-111-1111

843-222-2222

843-333-3333

-------------------

How do I keep my current setup but create a query that achieves the same result from the top? (Output the names from the People table as the group headers, but the data from the Phones table underneath that)