ColdFusion Query Loop Next Value

Hello I have query array with values

• cat_1 abc
• cat_1 bbb
• cat_1 ccc
• cat_2 abc
• cat_2 ooo
• cat_3 ppo

now I have to display this array in the following manner

cat_1

• abc
• bbb
• ccc

cat_2

• abc
• ooo

cat_3

• ppo

I have using a table with associations to get join data from categories and item tables but when I output it to my view. I am not sure how to get the next value of the row in the query loop.

<cfloop query="checklist">
#checklist.categoriesname# #checklist.name#
</cfloop>

Above is my current loop, I want to get the categoriesname once and if is the same as last not output it.

As suggested above, code resolve the issue for me.

<cfloop query="checklist" group="categoriesname">
#checklist.categoriesname#
<cfloop>
#checklist.name#
</cfloop>
</cfloop>