MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();


version()


8.0.36


create table my_tickets
( ticket_id int, user_id int);
insert into my_tickets values
( 186       , 2       ),
( 187       , 2       ),
( 188       , 2       ),
( 253       , 33      ),
( 254       , 33      ),
( 256       , 33      ),
( 261       , 33      ),
( 262       , 33      ),
( 263       , 33      ),
( 1573      , 7       ),
( 1748      , 7       );

create table my_users
( id int, name varchar(10)); 
insert into my_users values
( 2  , 'user_2'  ),
( 7  , 'user_7'  ),
( 33 , 'user_33' );

create table my_data
( id int, ticket_id int, data  varchar(20));    
insert into my_data values
( 1  , 186       , 'data_186_1' ),
( 2  , 186       , 'data_186_2' ),
( 3  , 187       , 'data_187_1' ),
( 4  , 253       , 'data_253_1' ),
( 5  , 253       , 'data_253_2' ),
( 6  , 253       , 'data_253_3' ),
( 7  , 254       , 'data_254_1' );


Records: 11  Duplicates: 0  Warnings: 0



Records: 3  Duplicates: 0  Warnings: 0



Records: 7  Duplicates: 0  Warnings: 0


select s.*,md.*,mu.name from
(select distinct user_id,ticket_id from my_tickets mt  where user_id = 33 limit 3) s
left join my_data md on md.ticket_id = s.ticket_id
join my_users mu on mu.id = s.user_id
order by s.ticket_id,id


user_id
ticket_id
id
ticket_id
data
name


33
253
4
253
data_253_1
user_33

33
253
5
253
data_253_2
user_33

33
253
6
253
data_253_3
user_33

33
254
7
254
data_254_1
user_33

33
256
null
null
null
user_33

user_id	ticket_id	id	ticket_id	data	name
33	253	4	253	data_253_1	user_33
33	253	5	253	data_253_2	user_33
33	253	6	253	data_253_3	user_33
33	254	7	254	data_254_1	user_33
33	256	null	null	null	user_33