A 10-year-old boy has died after a set of goalposts collapsed on him during a summer soccer camp in Co Limerick.