This is a physical defect. Macros make one key press effect one or more action button or key press. For instance if a common operation involves pressing a b and c in sequence you can make one button on your mouse actuate that sequence.

You can’t bind a macro to left click because then you can’t left click anymore. Even if you bound double clicking to single click (if this is even possible) it would mean every time it single click you would effect nothing which is equally if not more broken.

You need to either take your mouse apart and fix it or throw it in the trash.