Need help finding name of movie?

All I remember is there's a kid who's granfather is reading him a book
and the kid gets transported into the book and meets a mermaid, and
pirates who are treasure hunting.