[TOMT][MOVIES] Mermaid Movie (2000s)

I remember this mermaid movie i watched where the mermaid or siren had crawled into a mans bed and then ate his legs so she could have legs, leaving him in a bath tub with a tail.. i don’t remember the name or where i watched it but I’m desperate to find it again