Prayers have been held across the United States after the killing of nine people at a historic African-American church in Charleston, South Carolina.