Please help me find my childhood read 😭 fantasy/children book

Hi everyone, i read the book in my school library when i were in primary school (around 6-10 year old), so it must be published before 2005. I could only remember very little of the plot, about a boy going to other dimension to find something, maybe his dad, involved with sand or something... The feeling of the book imprinted into my head as a very dreamy and probably children book.

Please give me a list of book that gave u guy same idea and i will check one by one by myself later.

Please help me, this one stuck in my head forever and i made a reddit account just for this.

Thank you in advance 😭