print product category and product in the same page

[eluser]Bigil Michael[/eluser]
hi friens
i have 2 tables product category and product

i want to print the result like this

category(no.of product in that category)
eg: laptop(12)

can any one help me to write the query.

thanks in advance....