Four people have been killed and another five left critically injured after a gunman opened fire at a family football party in the California city of Fresno on Sunday night.