If you use Google+ and have a profile there, open the app. Tap the menu control top right in the red bar, then settings, then your account name (under account settings), then contacts, then turn on "keep contacts up to date".
This will populate the "Me" contact with your Google+ profile info, including the profile photo.