To get this trophy you need to live on a property with a grave or urn which appear after a Sim dies.
Every few nights a ghost will appear. You need to get the friendly interaction filled right to the top, then select "Invite To Household".
Ghosts will only come out late at night and return to their grave early in the morning.