There are a couple of options, and which to use depends on how your application connects to SQL Server.
But to keep things simple: the one you want in the plain-vanilla case is SYSTEM_USER:
This returns the current login. To confuse matter there is also SESSION_USER, suser_sname() and maybe some which I have forgotten. They are entirely equivalent.