Select By Foreign Key

shop.Name =

[Select Shopping__r.name From Goods__c where Name=:goods.Name]

.Shopping__r.name;