Self-consistent projection operator theory for quantum many-body systems