What glue should be used to accomplish this task?

What material is sink, and what material is the overflow ?

But generally speaking, silicon caulk should do good job. Just make sure both surfaces are perfectly clean ( clean with alcohol )

Hope that helps

Milo