Well as of now, just parents here, I'd like to talk from the kids POV.
I used to go up to my parents room middle of the night to snuggle up with my mum, till i think i was about 10. (23 Now and living on my own) and mum used to some times as some one said above walk me back to my bed or she would just skooch over and let me get under the covers.
I used to do this quite intentionally, as in not in sleep or unknowingly, even though when i was actually doing it I'd be half asleep, but I knew before going to sleep in my bed only thta after some time I'll go to mum. There was no specific 'reason' for this, I wasnt scared, me and the elder brother shared a big bed, I wasnt lonely either. It was just some thing that i wanted.
So just enjoy this. bond with your young one and give him all the attention he wants, and more.
Only recently I started having one on one conversations and connections with children, My girlfriend has a 10 year old daughter, and we bond quite well, we play together and go out all of us and we have quite a time. Children I have experienced can want a lot of your attention to the point you feel tired but when I am interested and willing to be with her, then its quite an exchange that happens.