Pilot reported during approach they overshot the approach; lost situational awareness and had a CFTT event. The Tower Controller instructed the pilot to climb immediately.

Narrative

I was about 7 miles west of the airport and released by ZZZ approach to ZZZ tower when I continued descent below 2200 feet MSL but was still 3 miles from the airport and lost situational awareness. The tower instructed me to climb immediately to 3000'; which I did as I maneuvered onto an extended left base leg for Runway XX right. Remainder of the approach and landing was uneventful. The landing was smooth (a 'squeaker') on the centerline at the proper speed and vertical approach profile. I taxied to the ramp. I had never flown in this area previously. The tower controller was emphatic that I climb immediately to 3000' which I complied as I entered the extended left base leg. After landing and securing the aircraft; the tower had asked that I call them; which I did. The tower supervisor discussed their concern over my unusual approach from the west and apparent loss of orientation/situational awareness. I thanked him and the controller for their assistance. This was a very unusual event for me. It caused me to be concerned with my poorly executed approach and loss of situational awareness. I have never had any accidents; violations; failed check rides; etc.I started the day prior with a call to move this from ZZZ1 to ZZZ. The weather forecast was not good but the next morning had excellent conditions so I was asked to depart early while the weather was good. I had slept only a couple hours before embarking on a 6-hour solo flight. I did not appreciate the level of fatigue I was experiencing. In reflecting; I was unable to manage a normally routine task and situational awareness suffered. It was a serious event for me and while I always had good visual ground reference it must have been very concerning to the tower. Recite and understand his concern. This event could have been avoided if I had refused the flight and accepted only when I was well rested. The brief good weather window made moving up the flight by a full day seem like a good idea and that was the trap I put myself into. Procedurally; I should have requested radar vectors to final since I was unfamiliar with the area and it was dusk. Alternatively; I could have just continued as an IFR procedure and flown a RNAV approach to Runway 01 right which would have been an uneventful conclusion.