方法一:
SELECT COUNT(*) FROM zn_supervise_state AS a INNER JOIN ( SELECT id FROM sys_organization WHERE sys_organization.id = '7' OR sys_organization.parent_id = '7' ) AS b ON a.organization_id = b.id
方法二:
SELECT COUNT(*) FROM zn_supervise_state WHERE zn_supervise_state.organization_id IN ( SELECT id FROM sys_organization WHERE sys_organization.id = '7' OR sys_organization.parent_id = '7' )