Two children have been killed and another two are fighting for their lives following a school shooting at a US church.