In crystal report, have to have three tables
table1, table2, table3(table1 with alias as table3)
yes, you can add single table multiple times with different aliases.
link table1.id to table2.head and table2.cato to table3.id
and now, place table1.category and table3.category in crystal report
That's it. It should do the trick for you.