Subcategories not showing up

I am using NopCommerce 3.0

I have added the parent categories and subcategories in the 'Category' table. Structure of my categories are as follows
Parent
   -Child1
      -Child2
When I add this through Administration panel it works. However I have written a stored procedure to load the category table and when the data is added to it, it does not show up the 'Child2'.

Thank you inadvance for the help.

Be sure Published is 1, and Deleted is 0.
"Clear the cache" in Admin  (If that does not work, then restart app)

Thank you very much for the reply.

However I have figured out why my subcategories were not populated.

I have to add a record in the UrlRecord table through the stored procedure. Once I did that the 2nd subcategories showed up.