What was the relationship between Caiaphas and Jesus?
They led Jesus to the house of Caiaphas. Caiaphas ordered him, by the living God, to say whether he was the Messiah, the Son of God. Matthew 26:57, 63-64
What the Bible says
Matthew 26:63
But Jesus held his peace. And the high priest said to him: I adjure thee by the living God, that thou tell us if thou be the Christ the Son of God.
Matthew 26:64
Jesus saith to him: Thou hast said it. Nevertheless I say to you, hereafter you shall see the Son of man sitting on the right hand of the power of God, and coming in the clouds of heaven.
Douay-Rheims Bible (Challoner revision), public domain.
What the Church teaches
The Catechism quotes Caiaphas: he said, prophesying, that it was better for one man to die for the people.
Catechism 596; John 11:49-50 · Catechism of the Catholic Church
Did you know?
John says that Caiaphas did not say this on his own: he prophesied that Jesus would die to gather the children of God. John 11:51-52