The police officer who tragically drowned while scuba diving at a popular Perth beach has been identified.