A seven-year-old boy whose dying wish was to be buried with his mother so she could look after him in Heaven has died peacefully in hospital.