如何计算父类别及其后代中的项目？

I have two tables: Category and Object. Category can have one or more children. These children can have their own children. So, the hierarchy is limitless. A child can have only one parent. Parent category is category where parent_id is NULL. Category has objects (one to many relationship).I have two tables: Category and Object. Categor