I need to get data from variable_value table – https://prnt.sc/19j4gk4
Then I need to change variable_id here to its name from parent table variable – https://prnt.sc/19j4to5
I want to get list of variables like that
id
2 TEST_var1_name 0 1 example html value
4 TEST_var1_name 1 NULL example html value for another store
I know, that I can use Collection from variable table. But how can I get data from child table?