Add `pipelines` endpoint to merge requests API

What does this MR do?

Add pipelines endpoint to merge requests API

Why was this MR needed?

There is no handy way to pull corresponding pipelines.

Does this MR meet the acceptance criteria?

• Changelog entry added, if necessary
• Documentation created/updated
• API support added
• Tests added for this feature/bug
• Review
  • Has been reviewed by UX
  • Has been reviewed by Frontend
  • Has been reviewed by Backend
  • Has been reviewed by Database
• Conform by the merge request performance guides
• Conform by the style guides
• Squashed related commits together
• Internationalization required/considered

What are the relevant issue numbers?

Closes #39214 (closed)