how can we count the number of products in nested level of sub categories and can show them with the parent category. Please help.
Show your table structure, some records, and the required output.