An Error Was Encountered

Error Number: 1052

Column 'prodcat_active' in where clause is ambiguous

SELECT child.* FROM product_cat parent JOIN product_cat child ON parent.prodcat_id = child.prodcat_parent_id AND child.prodcat_active = 1 WHERE prodcat_active = 1 AND parent.prodcat_active = 1 GROUP BY child.prodcat_id