Depends on ur closeness with that person.

If he's normal friend/acquaintance, say takziah/my condolences/I'm sorry etc.

If close friend, tell him you'll always be there for him/her.

Truth is, words could only bring very little comfort. He/she is bound to endure it. It's just whether it will be alone or not.