我在转换以下SQL查询以使用Laravel的查询构建器时遇到了很多麻烦。SELECT*FROMgiftsJOINgiftcategoryONgifts.id=giftcategory.giftidJOINgiftoccasionsONgifts.id=giftoccasions.giftidJOINgiftrelationshipONgifts.id=giftrelationship.giftidWHERE(gifts.gender='any'ORgifts.gender='male')ANDgiftoccasions.occasionid='2'AND(giftcategory.ca