Please advise about connection of cylindrical objects

Generate custom meshes that don’t overlap.

Else there really isn’t anything you can do about it.

See: Alpha/Transparency Sorting, Your Z-buffer, and You