Unfortunately you have just learned that you can't "loan" money to family or friends if you hold them dear. Next time you will just have to be the one "tapped out". The old saying goes something like if you want them to stay friends don't make the loan. It sounds like you will just have to write it off. Just accept it and let it go.