ALTER TABLE users
ADD CONSTRAINT fk_users_reporting_to
FOREIGN KEY (company_id, reporting_to)
REFERENCES users (company_id, id)
ON DELETE CASCADE;
