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.