It's a simple lead screw and nut mechanism where the pipe will raise the hopper. I've used screw mate yet rotating the nut won't raise the hopper but raising the hopper rotates
Introduction to SOLIDWORKS Mates: Standard, Advanced, & Mechanical | GoEngineer
Screw Mate in SolidWorks | Solidworks, Electronics components
Standard Mates – Introduction to SolidWorks
What Are the Mechanical Assembly Mates in SOLIDWORKS 2019?