looking for kitchen sink side drain repair

hello all, a strange question but ive seen some diy suggestions here before so I thought I might ask. The side of my kitchen sink unit has a little drain that is supposed to connnect up to the main pipe, but it has been leaking the last couple of days. I can feel on the pipe side that it moves around and is no longer fixed to the outside of the sink wall. I tried tightening the screw that the plug is attached to but the external pipe is stilll loose. Water that goes into it immediately spills out rather than drain into the main pipe. I couldn’t figure out online what to do — if I need to replace the connnecting pipe or if there is some kind of filler or glue that can be used to fix it in place. Anyone have any guidance? I would love to avoid having to call an expensive plumber if i dont have to.