SELECT count(*) c from categories where parent_id=34 4