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 do romantic interactions until you have the option to WooHoo. I WooHoo'd a ghost in the Hot Tub but no achievement. Use the bed.
Ghosts will only come out late at night and return to their grave early in the morning.